MySql快速造数据脚本

-- 插入大量随机数据的示例

DELIMITER //

CREATE PROCEDURE InsertTestData()

BEGIN

DECLARE v_counter INT DEFAULT 0;

WHILE v_counter < 1000 DO

INSERT INTO test_data (name, email) VALUES (UUID(), CONCAT(UUID(), '@example.com'));

SET v_counter = v_counter + 1;

END WHILE;

END//

DELIMITER ;

CALL InsertTestData();