-
- createdatabasespj
- go
- usespj
- go
- createtableS
- (
- Snochar(4)primarykey,
- Snamechar(20)unique,
- Statussmallint,
- Citychar(10)
- );
- createtableP
- (
- Pnochar(4)primarykey,
- Pnamechar(20),
- Colorchar(10),
- Weightsmallint,
- );
- createtableJ
- (
- Jnochar(4)primarykey,
- Jnamechar(20),
- Citychar(10)
- );
- createtableSPJ
- (
- Snochar(4),
- Pnochar(4),
- Jnochar(4),
- Qtysmallint,
- PRIMARYKEY(Sno,Pno,Jno),
- FOREIGNKEY(Sno)REFERENCESS(Sno),
- FOREIGNKEY(Pno)REFERENCESP(Pno),
- FOREIGNKEY(Jno)REFERENCESJ(Jno)
- );
- insertintoSvalues('S1','精益',20,'天津');
- insertintoSvalues('S2','盛锡',10,'北京');
- insertintoSvalues('S3','东方红',30,'北京');
- insertintoSvalues('S4','丰泰盛',20,'天津');
- insertintoSvalues('S5','为民',30,'上海');
- insertintoPvalues('P1','螺母','红',12);
- insertintoPvalues('P2','螺栓','绿',12);
- insertintoPvalues('P3','螺丝刀','蓝',12);
- insertintoPvalues('P4','螺丝刀','红',12);
- insertintoPvalues('P5','凸轮','蓝',12);
- insertintoPvalues('P6','齿轮','红',12);
- insertintoJvalues('J1','三建','北京');
- insertintoJvalues('J2','一汽','长春');
- insertintoJvalues('J3','弹簧厂','天津');
- insertintoJvalues('J4','造船厂','天津');
- insertintoJvalues('J5','机车厂','唐山');
- insertintoJvalues('J6','无线电厂','常州');
- insertintoJvalues('J7','半导体厂','南京');
- insertintoSPJvalues('S1','P1','J1',200);
- insertintoSPJvalues('S1','P1','J3',100);
- insertintoSPJvalues('S1','P1','J4',700);
- insertintoSPJvalues('S1','P2','J2',100);
- insertintoSPJvalues('S2','P3','J1',400);
- insertintoSPJvalues('S2','P3','J2',200);
- insertintoSPJvalues('S2','P3','J3',500);
- insertintoSPJvalues('S2','P3','J4',400);
- insertintoSPJvalues('S2','P5','J1',400);
- insertintoSPJvalues('S2','P5','J2',100);
- insertintoSPJvalues('S3','P1','J1',200);
- insertintoSPJvalues('S3','P3','J1',200);
- insertintoSPJvalues('S4','P5','J1',100);
- insertintoSPJvalues('S4','P6','J3',300);
- insertintoSPJvalues('S4','P6','J4',200);
- insertintoSPJvalues('S5','P2','J4',100);
- insertintoSPJvalues('S5','P3','J1',200);
- insertintoSPJvalues('S5','P6','J2',200);
- insertintoSPJvalues('S5','P6','J4',500);
- select*fromS
- select*fromP
- select*fromJ
- select*fromSPJ
SPJ数据库Sql语句
最新推荐文章于 2023-05-31 10:11:05 发布