SQL语句实现mysql数据库快速插入1000w条数据

CREATE PROCEDURE prod(IN in_count INT) 
BEGIN
    DECLARE COUNT INT DEFAULT 0;
    WHILE COUNT < in_count DO
        insert demo select * from demo;
        SET COUNT = COUNT + 1;
    END WHILE;
    #SELECT SUM;
END;

insert语句将demo表复制一遍，初始demo表中只有一条数据, 循环23次得2^n,一千万条数据