loop_mysql.sql

DROP PROCEDURE my_loop;

CREATE PROCEDURE my_loop ()
BEGIN
DECLARE
	i INT DEFAULT 7;
	WHILE (i < 78)
	DO INSERT INTO my_table (field_1, field_2)
		VALUES(i, 'test');
	SET i = i + 1;
END WHILE;
END;
	
CALL my_loop();