create table s --3
(
sno varchar(10) primary key,
sname varchar(10),
city varchar(12),
status varchar(12)
)
insert into s values('S1','精益','天津',20)
insert into s values('S2','盛锡','北京',10)
insert into s values('S3','东方红','北京',30)
insert into s values('S4','丰泰盛','天津',20)
insert into s values('S5','为民','上海',30)
create table j
(
jno varchar(10) primary key,
jname varchar(30),
city varchar(12)
)
insert into j values('J1','三建','北京')
insert into j values('J2','一汽','长春')
insert into j values('J3','弹簧厂','天津')
insert into j values('J4','造船厂','天津')
insert into j values('J5','机船厂','唐山')
insert into j values('J6','无线电厂','常州')
insert into j values('J7','半导体厂','南京')
create table p
(
pno varchar(10) primary key,
pname varchar(30),
color varchar(10),
weight int
)
insert into p values ('P1','螺母'