mysql批量创建测试数据
-- 批量插入脚本
DELIMITER $$
DROP PROCEDURE IF EXISTS proc_batch_insert $$
CREATE PROCEDURE proc_batch_insert()
BEGIN
DECLARE i INT;
SET i=1;
WHILE i < 1000 DO
INSERT INTO 表('OBJECT_ID','字段1') VALUES(UUID_SHORT(),'值1');
SET i=i+1;
END WHILE;
END $$DELIMITER ;
-- 调用脚本
call proc_batch_insert();