CREATE PROCEDURE e()
BEGIN
declare c char(30) character set utf8 ;
DECLARE i int default 1;
set c="测试";
WHILE(i <= 30000000) DO
insert into test values (i,CONCAT( c,i) );
SET i = i+1;
END WHILE;
END
原文：http://www.cnblogs.com/xkcp008/p/4056714.html