mysql如何实现循环插入千万级数据

CREATE PROCEDURE insertPro(in sum INT)BEGINDECLARE count INT DEFAULT 0;DECLARE i INT DEFAULT 0;

set @exesql = concat("insert into mysql_genarate(uuid) values");

set @exedata = "";

set count=0;

set i=0;while count<sum do

    set @exedata = concat(@exedata, ",(UUID())");

    set count=count+1;

    set i=i+1;    if i%1000=0

    then

        set @exedata = SUBSTRING(@exedata, 2);

        set @exesql = concat("insert into mysql_genarate(uuid) values ", @exedata);

        prepare stmt from @exesql;

        execute stmt;        DEALLOCATE prepare stmt;

        set @exedata = "";    end if;end while;if length(@exedata)>0 then

    set @exedata = SUBSTRING(@exedata, 2);

    set @exesql = concat("insert into mysql_genarate(uuid) values ", @exedata);

    prepare stmt from @exesql;

    execute stmt;    DEALLOCATE prepare stmt;end if;end;