DELIMITER $$
CREATE PROCEDURE genRecords()
BEGIN
DECLARE x INT DEFAULT 1;
WHILE x < 10 DO
INSERT INTO people (username, age) VALUES ('bob', 34)
SET x = x + 1;
END WHILE;
END;
$$
DELIMITER ;
call genRecords();
/* Delete procedure before modifiying it and creating a new one */
DROP PROCEDURE IF EXISTS genRecords;