duplicate_table.sql

DELIMITER $$
DROP PROCEDURE IF EXISTS duplicate_rows$$
CREATE PROCEDURE duplicate_rows (IN tablename VARCHAR(255), IN times INT)
BEGIN
    SET @statement = CONCAT(CONCAT(CONCAT(CONCAT("INSERT INTO ",tablename)," SELECT * FROM "),tablename),";");
    PREPARE stmt FROM @statement;
    WHILE times > 0 DO
      SELECT times as "Remaining";
      EXECUTE stmt;
      SET times = times - 1;
    END WHILE;
    DEALLOCATE PREPARE stmt;
END
$$