Mysql 循环插入数量级数据 供大数据测试
1:定义存储过程DELIMITER $$CREATE PROCEDURE dowhile2() BEGIN DECLARE i INT DEFAULT 0; START TRANSACTION; WHILE i INSERT INTO t_user VALUES(UUID_SHORT(),i,'测试数据'); SET i=i