14c03-1.sql

来自「介绍PHP5的给类型函数应用」· SQL 代码 · 共 10 行

create table tools (
	id   serial,
	desc varchar(255) not null,
	qty  int          not null,
	primary key(id)
);

insert into tools (desc, qty) values ('Screwdriver', 10);
insert into tools (desc, qty) values ('Tablesaw', 1);
insert into tools (desc, qty) values ('Router', 2);