2021-10-24

最新推荐文章于 2022-07-01 09:20:08 发布

zhidaobu00

最新推荐文章于 2022-07-01 09:20:08 发布

阅读量80

点赞数

文章标签： 1024程序员节

本文链接：https://blog.csdn.net/m0_57114395/article/details/120941017

版权

mysql> create table S (sno char(4) primary key, sname char(4), status int, city
char(4));
Query OK, 0 rows affected (0.01 sec)
mysql> describe S;
+--------+---------+------+-----+---------+-------+
| Field  | Type    | Null | Key | Default | Extra |
+--------+---------+------+-----+---------+-------+
| sno    | char(4) | NO   | PRI | NULL    |       |
| sname  | char(4) | YES  |     | NULL    |       |
| status | int     | YES  |     | NULL    |       |
| city   | char(4) | YES  |     | NULL    |       |
+--------+---------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> insert into S values('s2','精益',20,'天津'),('s3','精益',20,'天津'),('s4','精益',20,'天津'),('s5','精益',20,'天津');
Query OK, 4 rows affected (0.00 sec)
Records: 4  Duplicates: 0  Warnings: 0
mysql> select * from S;
+-----+--------+--------+--------+
| sno | sname  | status | city   |
+-----+--------+--------+--------+
| s1  | 精益   |     20 | 天津   |
| s2  | 精益   |     20 | 天津   |
| s3  | 精益   |     20 | 天津   |
| s4  | 精益   |     20 | 天津   |
| s5  | 精益   |     20 | 天津   |
+-----+--------+--------+--------+
5 rows in set (0.00 sec)
mysql> insert into spj values('s2','p1','j1',500),('s2','p1','j3',700),('s2','j3','j4',800),('s2','p2','j2',400);
Query OK, 4 rows affected (0.01 sec)
Records: 4  Duplicates: 0  Warnings: 0
mysql> select * from spj;
+------+------+------+------+
| sno  | pno  | jno  | qty  |
+------+------+------+------+
| s1   | p1   | j1   |  200 |
| s1   | p1   | j3   |  100 |
| s1   | j3   | j4   |  700 |
| s1   | p2   | j2   |  100 |
| s2   | p1   | j1   |  500 |
| s2   | p1   | j3   |  700 |
| s2   | j3   | j4   |  800 |
| s2   | p2   | j2   |  400 |
+------+------+------+------+
8 rows in set (0.00 sec)
mysql> create table j (jno char(2) primary key unique,jname char(2),city char(2));
Query OK, 0 rows affected (0.01 sec)
mysql> insert into j values('j1','三建','北京'),('j2','一汽','长春'),('j3','弹簧','天津'),('j4','天津','天津');
Query OK, 4 rows affected (0.01 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql> select * from spj;
+------+------+------+------+
| sno  | pno  | jno  | qty  |
+------+------+------+------+
| s1   | p1   | j1   |  200 |
| s1   | p1   | j3   |  100 |
| s1   | j3   | j4   |  700 |
| s1   | p2   | j2   |  100 |
| s2   | p1   | j1   |  500 |
| s2   | p1   | j3   |  700 |
| s2   | j3   | j4   |  800 |
| s2   | p2   | j2   |  400 |
+------+------+------+------+
8 rows in set (0.00 sec)
mysql> insert into j values('j5','三建','北京'),('j6','一汽','长春'),('j7','弹簧','天津'),('j8','天津','天津');
Query OK, 4 rows affected (0.00 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql> select * from j;
+-----+--------+--------+
| jno | jname  | city   |
+-----+--------+--------+
| j1  | 三建   | 北京   |
| j2  | 一汽   | 长春   |
| j3  | 弹簧   | 天津   |
| j4  | 天津   | 天津   |
| j5  | 三建   | 北京   |
| j6  | 一汽   | 长春   |
| j7  | 弹簧   | 天津   |
| j8  | 天津   | 天津   |
+-----+--------+--------+
8 rows in set (0.00 sec)