CREATE PROCEDURE prod(IN in_count INT)
BEGIN
DECLARE COUNT INT DEFAULT 0;
WHILE COUNT < in_count DO
insert demo select * from demo;#2^n 即循环23次
SET COUNT = COUNT + 1;
END WHILE;
#SELECT SUM;
END;
原文：https://www.cnblogs.com/liuyongliu/p/11855637.html