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';