shipper.sql

来自「卡内基梅隆大学软件工程课件,很全面」· SQL 代码 · 共 12 行

drop table stock;

create table stock  
(product_id varchar(3) constraint pk_stock primary key,  
quantity_on_hand integer,
reorder_level integer);

insert into stock  
values ('123', 100, 90);

exit;