mysql使用存储过程批量插入百万、千万测试数据

		        

delimiter //

DROP PROCEDURE IF EXISTS insert_test;

CREATE PROCEDURE insert_test()

BEGIN

SET    ​@num=0;

label:    ​LOOP

    ​SET    ​@num = @num+1;

    ​INSERT INTO test(record_id,name,sex) VALUES (REPLACE(UUID(),"-",""),"张三","男" );

    ​-- 如果num大于一百万，结束循环

    ​IF @num>1000000    ​THEN

    ​    ​LEAVE    ​label;

    ​END IF;

END LOOP label;

END;

//