建表1.sql

数据库方面的知识 最基本的建表

create table S
(
  SNO char(8),
  SNAME char(10),
  STATUS int,
  CITY char(10),
)

create table P
(
  PNO char (8),
  PNAME char(10),
  COLOR char(4),
  WEIGHT int,
)

create table J
(
  JNO char(8),
  JNAME char(10),
  CITY char(10),
)

create table SPJ
(
  SNO char(8),
  PNO char(8),
  JNO char(8),
  QTY char(8),
)

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,'上海');