Question

Mysql的批量插入语句怎么写？

比如这条：
INSERT INTO `a1`.`tutorial` (
`user_id` ,
`id` ,
`step` ,
`complete_time` ,
`update_time` ,
`record_time`
)
VALUES(
'3', '2', '8', '131477518',
CURRENT_TIMESTAMP , '131477498'
),(
'3', '3', '7', '131477518',
CURRENT_TIMESTAMP , '131477498'
),(
'3', '4', '11', '131477518',
CURRENT_TIMESTAMP , '131477498'
),(
'3', '5', '17', '131477518',
CURRENT_TIMESTAMP , '131477498'
),(
'3', '6', '9', '131477518',
CURRENT_TIMESTAMP , '131477498'
);
我要从user_id=10 一直修改到 user_id=99 每个ID都要插像上面这种的五条数据
不可能一直这样复制黏贴吧..
所以想问问Mysql中有没有循环之类的呀.

Answer 1

INSERT INTO `a1`.`tutorial` ( `user_id` , `id` , `step` , `complete_time` , `update_time` , `record_time` ) VALUES( '3', '2', '8', '131477518', CURRENT_TIMESTAMP , '131477498' ),( '3', '3', '7...

Answer 2

INSERT INTO 表名(字段名1,字段名2┈┈字段名N) VALUES(值1,值2┈┈值N)

Answer 3

语句中用";"分号隔开。。这样可以一起执行。

Answer 4

insert into table
select * from table

Answer 5

insert into table
select * from table1