Question

如何使用MySQL实现批量插入数据

Answer 1

用存储过程，写个循环给你个我以前写的看看
begin
declare i int;
declare b int;
declare c int;
set @i=2;
set @b=6;
set @c=0;
set @stmt = concat('insert into t_j_goods_name (id,`code`,`name`)
values(?,?,(select distinct `a` from sheet1 limit ?, 1))');
while @i<442 do
prepare s1 from @stmt;

execute s1 using @b,@i,@c;

deallocate prepare s1;
set @i=@i+1,@b=@b+1,@c=@c+1;

end while;
end

Answer 2

量受理舅绿暧昧奄