循环1W次随便插入数据测试:
-- 循环1万次,向user表中的count字段插入数据1到10000
DROP PROCEDURE IF EXISTS proc_initData;-- 如果存在此存储过程则删掉
DELIMITER $
CREATE PROCEDURE proc_initData()
BEGIN
DECLARE i INT DEFAULT 1;
WHILE i<=10000 DO
INSERT INTO user(count) VALUES(i);
SET i = i+1;
END WHILE;
END $
CALL proc_initData();
转载自:https://blog.csdn.net/lizhengyu891231/article/details/101768139