数据库管理二.docVIP

向表中插入数据 DML语句 插入的语法 insert into 表名 [( 字段名1[,..字段名n ])] values ( 值1 )[, ( 值n )] 建造一个简单的表 CREATE TABLE `test` ( `id` int(4) NOT NULL AUTO_INCREMENT, `name` char(20) NOT NULL, PRIMARY KEY (`id`) ) ; 插入数据 地一种方法 mysql insert into test(id,name) values(1,oldboy); Query OK, 1 row affected (0.00 sec) mysql select * from test; +----+--------+ | id | name | +----+--------+ | 1 | oldboy | +----+--------+ 1 row in set (0.03 sec) mysql 由于ID设置了自增 mysql insert into test(name) values(oldboy); Query OK, 1 row affected (0.00 sec) mysql select * from test; +----+--------+ | id | name | +----+--------+ | 1 | oldboy | | 2 | oldgirl| +----+--------+ 2 rows in set (0.00 sec) 批量插入 mysql insert into test values(4,zuma),(5,kaka); Query OK, 2 rows affected (0.00 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql INSERT INTO `test` VALUES (1,oldboy),(2,oldgirl),(3,inca),(4,zuma),(5,kaka); Query OK, 5 rows affected (0.00 sec) Records: 5 Duplicates: 0 Warnings: 0 mysql select * from test; +----+---------+ | id | name | +----+---------+ | 1 | oldboy | | 2 | oldgirl | | 3 | inca | | 4 | zuma | | 5 | kaka | +----+---------+ 5 rows in set (0.00 sec) 查询语句 mysql select * from test; +----+---------+ | id | name | +----+---------+ | 1 | oldboy | | 2 | oldgirl | | 3 | inca | | 4 | zuma | | 5 | kaka | +----+---------+ 5 rows in set (0.00 sec) 查询部分列 mysql select name,id from test; +---------+----+ | name | id | +---------+----+ | oldboy | 1 | | oldgirl | 2 | | inca | 3 | | zuma | 4 | | kaka | 5 | +---------+----+ 5 rows in set (0.00 sec) 查询部分行 mysql select name,id from test limit 2; +---------+----+ | name | id | +---------+----+ | oldboy | 1 | | oldgirl | 2 | +---------+----+ 2 rows in set (0.00 sec) 从第一条记录以后开始，查询两条数据 mysql select name,id from test limit 1,2; +---------+----+ | name | id | +---------+----+ | oldgirl | 2 | | inca | 3 | +---------+----+ 2 rows in set (0.00 sec) 按条件查