sql语句----表管理插入内容（ insert into）-CSDN博客

博客围绕SQL和MySQL数据库展开，虽未给出具体内容，但可知聚焦于这两种数据库技术，它们在信息技术领域的数据库管理中应用广泛。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

对表中存储的行做管理 ，
操作包括  查看select   插入 insert into    
mysql> create table stu3(number int ,name char(10),age int,gender char(4) );
Query OK, 0 rows affected (0.03 sec)

mysql> desc stu3;
+--------+----------+------+-----+---------+-------+
| Field  | Type     | Null | Key | Default | Extra |
+--------+----------+------+-----+---------+-------+
| number | int(11)  | YES  |     | NULL    |       |
| name   | char(10) | YES  |     | NULL    |       |
| age    | int(11)  | YES  |     | NULL    |       |
| gender | char(4)  | YES  |     | NULL    |       |
+--------+----------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> insert into stu3 values(2,"ll",12,"boy");
Query OK, 1 row affected (0.00 sec)

mysql> insert into stu3 values(3,"qq",16,"girl");
Query OK, 1 row affected (0.00 sec)

mysql> select * from stu3 ;
+--------+------+------+--------+
| number | name | age  | gender |
+--------+------+------+--------+
|      1 | jj   |   10 | boy    |
|      2 | ll   |   12 | boy    |
|      3 | qq   |   16 | girl   |
+--------+------+------+--------+
3 rows in set (0.00 sec)


mysql> insert into stu3(number,name) values(12,"qiuqiu");
Query OK, 1 row affected (0.00 sec)

mysql> select * from stu3;
+--------+--------+------+--------+
| number | name   | age  | gender |
+--------+--------+------+--------+
|      1 | jj     |   10 | boy    |
|      2 | ll     |   12 | boy    |
|      3 | qq     |   16 | girl   |
|     12 | qiuqiu | NULL | NULL   |
+--------+--------+------+--------+
4 rows in set (0.00 sec)

mysql> insert into stu3(number,name) values(15,"lili"), (17 ,"rourou");
Query OK, 2 rows affected (0.01 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> select * from stu3;
+--------+--------+------+--------+
| number | name   | age  | gender |
+--------+--------+------+--------+
|      1 | jj     |   10 | boy    |
|      2 | ll     |   12 | boy    |
|      3 | qq     |   16 | girl   |
|     12 | qiuqiu | NULL | NULL   |
|     15 | lili   | NULL | NULL   |
|     17 | rourou | NULL | NULL   |
+--------+--------+------+--------+
6 rows in set (0.00 sec)
mysql> insert into stu3 set number=16,name="wuwu" ;
Query OK, 1 row affected (0.01 sec)

mysql> select * from stu3;
+--------+--------+------+--------+
| number | name   | age  | gender |
+--------+--------+------+--------+
|      1 | jj     |   10 | boy    |
|      2 | ll     |   12 | boy    |
|      3 | qq     |   16 | girl   |
|     12 | qiuqiu | NULL | NULL   |
|     15 | lili   | NULL | NULL   |
|     17 | rourou | NULL | NULL   |
|     16 | wuwu   | NULL | NULL   |
+--------+--------+------+--------+
7 rows in set (0.00 sec)
mysql> insert into stu3(number,name) (select number,name from stu3 where name  in ("jj"));
Query OK, 1 row affected (0.01 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> select * from stu3;                                                      +--------+--------+------+--------+
| number | name   | age  | gender |
+--------+--------+------+--------+
|      1 | jj     |   10 | boy    |
|      2 | ll     |   12 | boy    |
|      3 | qq     |   16 | girl   |
|     12 | qiuqiu | NULL | NULL   |
|     15 | lili   | NULL | NULL   |
|     17 | rourou | NULL | NULL   |
|     16 | wuwu   | NULL | NULL   |
|      1 | jj     | NULL | NULL   |
+--------+--------+------+--------+
8 rows in set (0.00 sec)