mysql循环插入数据示例

DROP PROCEDURE IF EXISTS proc_initData;–如果存在此存储过程则删掉
DELIMITER $
CREATE PROCEDURE proc_initData()
BEGIN
DECLARE i INT DEFAULT 1;
WHILE i<=10000 DO
insert into mytable (字段1,字段2,字段3) values (值1,值2,值3);
SET i = i+1;
END WHILE;
END $
CALL proc_initData();$