MySQL使用INSERT语句向数据表中添加数据

MySQL使用INSERT语句向数据表中添加数据

插入数据是向已经存在的数据表中添加一条新的记录，应该使用INSERT INTO语句。

格式：

INSERT INTO 表名 [(字段名1,字段名2,…字段名n)] VALUES(‘值1’,‘值2’,…,’值n’);

或者

INSERT INTO 表名 [(字段名1,字段名2,…字段名n)] VALUES(‘值1’,‘值2’，…，‘值n’),VALUES(‘值1’,‘值2’,…,’值n’);

mysql>
-- 1. 数据的添加
--===========================================
-- 指定所有字段添加所有的值
mysql> insert into stu(id,name,age,sex,classid) values(1,'zhangsan',20,'m','lamp110');
Query OK, 1 row affected (0.09 sec)

-- 不指定字段添加值
mysql> insert into stu values(2,'lisi',22,'w','lamp110');
Query OK, 1 row affected (0.01 sec)

-- 指定部分字段添加值
mysql> insert into stu(name,age,classid) values("wangwu",28,'lamp106');
Query OK, 1 row affected (0.03 sec)

-- 批量添加值
mysql> insert into stu values
    -> (null,'zhaoliu',31,'m','lamp110'),
    -> (null,'xiaowang',18,'w','lamp111'),
    -> (null,'laowang',38,'m','lamp106'),
    -> (null,'xiaoli',28,'w','lamp110'),
    -> (null,'uu01',21,'w','lamp110'),
    -> (null,'uu02',25,'m','lamp110'),
    -> (null,'uu03',25,'m','lamp106'),
    -> (null,'uu04',25,'m','lamp106'),
    -> (null,'uu05',25,'m','lamp106'),
    -> (null,'uu06',25,'m','lamp106'),
    -> (null,'uu07',25,'m','lamp106'),
    -> (null,'uu08',25,'m','lamp106');
Query OK, 12 rows affected (0.03 sec)
Records: 12  Duplicates: 0  Warnings: 0

mysql> select * from stu;
+----+----------+-----+-----+---------+
| id | name     | age | sex | classid |
+----+----------+-----+-----+---------+
|  1 | zhangsan |  20 | m   | lamp110 |
|  2 | lisi     |  22 | w   | lamp110 |
|  3 | wangwu   |  28 | m   | lamp106 |
|  4 | zhaoliu  |  31 | m   | lamp110 |
|  5 | xiaowang |  18 | w   | lamp111 |
|  6 | laowang  |  38 | m   | lamp106 |
|  7 | xiaoli   |  28 | w   | lamp110 |
|  8 | uu01     |  21 | w   | lamp110 |
|  9 | uu02     |  25 | m   | lamp110 |
| 10 | uu03     |  25 | m   | lamp106 |
| 11 | uu04     |  25 | m   | lamp106 |
| 12 | uu05     |  25 | m   | lamp106 |
| 13 | uu06     |  25 | m   | lamp106 |
| 14 | uu07     |  25 | m   | lamp106 |
| 15 | uu08     |  25 | m   | lamp106 |
+----+----------+-----+-----+---------+
15 rows in set (0.05 sec)

欢迎转载，转载需注明地址： http://www.luowebs.com/Skill_desc/32/486.html

很赞哦！ (0)