假设已知student表有sno,sname,sex字段,如下语句可实现批量插入10000条记录。
create PROCEDURE bathInsertData()
BEGIN
DECLARE i int DEFAULT 0;
while i<100000 DO
INSERT into student(sno,sname,sex) values(i,'hellen','男');
set i=i+1;
end while;
end
假设已知student表有sno,sname,sex字段,如下语句可实现批量插入10000条记录。
create PROCEDURE bathInsertData()
BEGIN
DECLARE i int DEFAULT 0;
while i<100000 DO
INSERT into student(sno,sname,sex) values(i,'hellen','男');
set i=i+1;
end while;
end