先执行:(表名:number,字段(id,名字,性别,手机号))
DROP PROCEDURE IF EXISTS proc_initData1;
CREATE PROCEDURE proc_initData1()
BEGIN
DECLARE i INT DEFAULT 1;
WHILE i<=10000 DO
INSERT INTO `number` VALUES(NULL,"李梅","男","1");
SET i = i+1;
END WHILE;
END
后执行:
CALL proc_initData1();