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

存储过程