1. 插入完整数据(顺序插入)
语法一:
INSERT INTO 表名(字段1,字段2,字段3…字段n) VALUES(值1,值2,值3…值n);
语法二:
INSERT INTO 表名 VALUES (值1,值2,值3…值n);
2. 指定字段插入数据
语法:
INSERT INTO 表名(字段1,字段2,字段3…) VALUES (值1,值2,值3…);
3. 插入多条记录
语法:
INSERT INTO 表名 VALUES
(值1,值2,值3…值n),
(值1,值2,值3…值n),
(值1,值2,值3…值n);
4. 插入查询结果
语法:
INSERT INTO 表名(字段1,字段2,字段3…字段n)
SELECT (字段1,字段2,字段3…字段n) FROM 表2
WHERE …;
实例:
mysql> insert into auth (id,name,age,address) values (null,'fuyong',18,'河南');
Query OK, 1 row affected (0.05 sec)
mysql> insert into auth values(null,'xiaohua',16,'四川');
Query OK, 1 row affected (0.07 sec)
mysql> insert into auth (id,name) values (null,'小明');
Query OK, 1 row affected (0.05 sec)
mysql> insert into auth value(null,'勒布朗',33,'克利夫兰'),(null,'科比',42,'洛杉矶');
Query OK, 2 rows affected (0.07 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> insert into auth2 select * from auth;
Query OK, 6 rows affected (0.06 sec)
Records: 6 Duplicates: 0 Warnings: 0
语法:
UPDATE 表名 SET
字段1=值1,
字段2=值2,
WHERE CONDITION;
实例如下:
mysql> update auth set name = '付勇' where id = 2;
Query OK, 1 row affected (0.03 sec)
Rows matched: 1 Changed: 1 Warnings: 0
语法:
DELETE FROM 表名
WHERE CONITION;
mysql> delete from auth where id = 1;
Query OK, 1 row affected (0.04 sec)
delete
from
表名
mysql> delete from auth2;
Query OK, 6 rows affected (0.09 sec)
truncate
table
表名;
mysql> truncate table auth2;
Query OK, 0 rows affected (0.28 sec)
http://www.cnblogs.com/fu-yong/p/8495469.html