DELIMITER ;;
CREATE PROCEDURE author_insert ()
BEGIN
DECLARE i INT DEFAULT 0;
WHILE i<100
DO
INSERT INTO author(name, email) VALUES(‘name‘, CONCAT(‘email@‘,i));
SET i=i+1;
END WHILE ;
END;;
CALL author_insert();
原文：http://www.cnblogs.com/BigBigLiang/p/4818768.html