CREATETABLES(
SNOchar(2)primarykey,
SNAMEvarchar(20),
STATUSchar(4),
CITYchar(10)
);
createtableP(
PNOchar(2)primarykey,
PNAMEvarchar(20),
COLORchar(4),
WEIGHTint
);
createtableJ(
JNOchar(2)primarykey,
JNAMEvarchar(20),
CITYchar(10)
);
createtableSPJ(
SNOchar(2),
PNOchar(2),
JNOchar(2),
QTYint,
primarykey(SNO,PNO,JNO),
foreignkey(SNO)referencesS(SNO)ondeletecascade,
foreignkey(PNO)referencesP(PNO)ondeletecascade,
foreignkey(JNO)referencesJ(JNO)ondeletecascade
);

顺便连数据也一起给你好了

insertintoSvalues('S1','供应商一','良好','郑州');
insertintoSvalues('S2','供应商二','良好','天津');
insertintoSvalues('S3','供应商三','良好','上海');
insertintoSvalues('S4','供应商四','优秀','郑州');
insertintoPvalues('P1','管材','红色',20);
insertintoPvalues('P2','管线','绿色',30);
insertintoPvalues('P3','螺帽','红色',10);
insertintoPvalues('P4','螺帽','黄色',10);
insertintoJvalues('J1','一建工程','郑州');
insertintoJvalues('J2','二建工程','郑州');
insertintoJvalues('J3','三建工程','天津');
insertintoJvalues('J4','四建工程','天津');
insertintoJvalues('J5','五建工程','上海');
insertintoJvalues('J6','六建工程','北京');
insertintoSPJvalues('S1','P1','J1',100);
insertintoSPJvalues('S1','P2','J1',100);
insertintoSPJvalues('S2','P1','J1',100);
insertintoSPJvalues('S2','P2','J1',100);
insertintoSPJvalues('S1','P1','J3',100);
insertintoSPJvalues('S1','P2','J3',100);
insertintoSPJvalues('S2','P1','J3',100);
insertintoSPJvalues('S2','P2','J3',100);
insertintoSPJvalues('S3','P1','J2',100);
insertintoSPJvalues('S3','P2','J2',100);
insertintoSPJvalues('S4','P3','J2',100);

本文地址： http://www.goggeous.com/20241218/1/749210

文章来源：天狐定制

版权声明：除非特别标注，否则均为本站原创文章，转载时请以链接形式注明文章出处。