J表创建代码，P表创建代码，SPJ表创建代码，S表创建代码

不会编头发

已于 2022-10-02 18:32:48 修改

阅读量331

点赞数

文章标签：数据库

于 2022-10-02 18:28:34 首次发布

本文链接：https://blog.csdn.net/qq_51191109/article/details/127145036

版权

J表创建代码

CREATE TABLE J

(JNO Char(9) PRIMARY KEY,

JNAME CHAR(15) UNIQUE,

CITY CHAR(10) ,

);

INSERT 

INTO J(JNO,JNAME,CITY)

VALUES('J1','三建','北京');

INSERT 

INTO J(JNO,JNAME,CITY)

VALUES('J2','一汽','长春');

INSERT 

INTO J(JNO,JNAME,CITY)

VALUES('J3','弹簧厂','天津');

INSERT 

INTO J(JNO,JNAME,CITY)

VALUES('J4','造船厂','天津');

INSERT 

INTO J(JNO,JNAME,CITY)

VALUES('J5','机车厂','唐山');

INSERT 

INTO J(JNO,JNAME,CITY)

VALUES('J6','无线电厂','常州');

INSERT 

INTO J(JNO,JNAME,CITY)

VALUES('J7','半导体厂','南京');

P表创建代码

CREATE TABLE P

(PNO Char(9) PRIMARY KEY,

PNAME CHAR(15),

COLOR CHAR(15),

WEIGHT CHAR,

);*/

INSERT 

INTO P(PNO,PNAME,COLOR,WEIGHT)

VALUES('P1','螺母','红',12);

INSERT 

INTO P(PNO,PNAME,COLOR,WEIGHT)

VALUES('P2','螺栓','绿',17);

INSERT 

INTO P(PNO,PNAME,COLOR,WEIGHT)

VALUES('P3','螺丝刀','蓝',14);

INSERT 

INTO P(PNO,PNAME,COLOR,WEIGHT)

VALUES('P4','螺丝刀','红',14);

INSERT 

INTO P(PNO,PNAME,COLOR,WEIGHT)

VALUES('P5','凸轮','蓝',40);

INSERT 

INTO P(PNO,PNAME,COLOR,WEIGHT)

VALUES('P6','齿轮','红',30);

SPJ表创建代码

CREATE TABLE SPJ(

SNO CHAR(9),

PNO CHAR(10),

JNO CHAR(5),

QTY CHAR(5) );

INSERT INTO SPJ VALUES('S1','P1','J1',200);

INSERT INTO SPJ VALUES('S1','P1','J3',100);

INSERT INTO SPJ VALUES('S1','P1','J4',700);

INSERT INTO SPJ VALUES('S1','P2','J2',100); 

INSERT INTO SPJ VALUES('S2','P3','J1',400);

INSERT INTO SPJ VALUES('S2','P3','J2',200);

INSERT INTO SPJ VALUES('S2','P3','J4',500);

INSERT INTO SPJ VALUES('S2','P3','J5',400);

INSERT INTO SPJ VALUES('S2','P5','J1',400);

INSERT INTO SPJ VALUES('S2','P5','J2',100);

INSERT INTO SPJ VALUES('S3','P1','J1',200);

INSERT INTO SPJ VALUES('S3','P3','J1',200);

INSERT INTO SPJ VALUES('S4','P5','J1',100);

INSERT INTO SPJ VALUES('S4','P6','J3',300);

INSERT INTO SPJ VALUES('S4','P6','J4',200);

INSERT INTO SPJ VALUES('S5','P2','J4',100);

INSERT INTO SPJ VALUES('S5','P3','J1',200);

INSERT INTO SPJ VALUES('S5','P6','J2',200);

INSERT INTO SPJ VALUES('S5','P6','J4',500);

S表创建代码

CREATE TABLE S

(SNO CHAR(9)PRIMARY KEY,

SNAME CHAR(20)UNIQUE,

STATUS CHAR(4),

CITY CHAR(4),

);



INSERT

INTO S(SNO,SNAME,STATUS,CITY)

VALUES('S1','精益','20','天津');

INSERT

INTO S(SNO,SNAME,STATUS,CITY)

VALUES('S2','盛锡','10','北京');

INSERT

INTO S(SNO,SNAME,STATUS,CITY)

VALUES('S3','东方红','30','北京');

INSERT

INTO S(SNO,SNAME,STATUS,CITY)

VALUES('S4','丰泰盛','20','天津');

INSERT

INTO S(SNO,SNAME,STATUS,CITY)

VALUES('S5','为民','30','上海');