SQL 数据库操作：添加供应商和产品示例

INSERT INTO Suppliers (CompanyName) VALUES ('CCNU'); INSERT INTO Products (ProductName, SupplierID) VALUES ('CCNU Soya-bean milk', (SELECT SupplierID FROM Suppliers WHERE CompanyName = 'CCNU'));

-- 查询是否成功添加 SELECT * FROM Suppliers WHERE CompanyName = 'CCNU'; SELECT * FROM Products WHERE ProductName = 'CCNU Soya-bean milk';