mysql创建存储过程造数据
delimiter $$$ DROP PROCEDURE zqtest6; create procedure zqtest6() begin declare i int default 0; set i=1; start transaction; while i<100do // insert into tablename (columnname) values (i); set i=i+1; end while; commit; end $$$ delimiter; call zqtest6();