MySQL使用存储过程创建100W条数据

delimiter ;;
create procedure table2()

begin

SET @a=1000000;
WHILE @a>0 DO
SET @b='sdlyjhm01@sina.com';
SET @c='jiang';
SET @d='huimin';
INSERT INTO EMPLOYEE(ID, EMAIL,FIRST_NAME,LAST_NAME)
VALUES(@a, @b, @c, @d);
SET @a=@a-1;
end while ;
end;;

call table();;



//查看存储过程
select `name` from MySQL.proc where db = 'desp' and `type` = 'PROCEDURE'

存储过程里不能有错误，否则在执行的时候就会有莫名其妙的错误