Procedure to populate table

The procedure below allows you to populate table using number of new records as a parameter.

CREATE DEFINER=`root`@`%` PROCEDURE `database`.`addToTable`(add_records int)
BEGIN
	DECLARE auto_inc int DEFAULT (SELECT IFNULL(MAX(id), 0) FROM database.table);
    DECLARE i int DEFAULT auto_inc;
    WHILE i < (auto_inc + add_records) DO
	    SET i = i + 1;
        INSERT INTO database.table
			(id, name)
			VALUES(i, ‘John Doe’);
    END WHILE;
END