DROP PROCEDURE IF EXISTS proc_initData;
DELIMITER $
CREATE PROCEDURE proc_initData()
BEGIN
DECLARE i INT DEFAULT 1;
WHILE i<=10000 DO
INSERT INTO 表名(id) VALUES(i);
SET i = i+1;
END WHILE;
END $
CALL proc_initData()
mysql通过查询造10000条测试数据
最新推荐文章于 2024-07-18 04:07:50 发布