MYSQL存储过程随机插入百万数据

create PROCEDURE test_insert()
BEGIN	
	DECLARE i int DEFAULT 1;
	while i<1000000
		DO
			insert into test(name,ke,score) VALUES ('张三','英文',ROUND(rand()*100) );
  insert into test(name,ke,score) VALUES ('张三','数学',ROUND(rand()*100) );
  insert into test(name,ke,score) VALUES ('张三','语文',ROUND(rand()*100) );
		set i = i+1;
	END WHILE;
	COMMIT;
END#

删除 drop PROCEDURE test_insert;

调用 call test_insert;

终止 show processlist ; kill pid