product.sql

来自「BigC++的源码」· SQL 代码 · 共 6 行

CREATE TABLE Product (Product_Code CHAR(10),Description CHAR(40), Unit_Price DECIMAL(10,2))
INSERT INTO Product VALUES ('116-064', 'Toaster', 24.95)
INSERT INTO Product VALUES ('257-535', 'Hair dryer', 29.95)
INSERT INTO Product VALUES ('643-119', 'Car vacuum', 19.95)
SELECT * FROM Product