NorikDavtian · January 7, 2022 03:43 · NorikDavtian · Jan 7, 2022
diff --git a/MYSQL DO WHILE LOOP LOADGEN.sql b/MYSQL DO WHILE LOOP LOADGEN.sql
 DELIMITER $$
 CREATE PROCEDURE LOADGEN(SIZE INT)
    DETERMINISTIC
    READS SQL DATA
 BEGIN
    DECLARE i INT unsigned DEFAULT 1;
    WHILE (i <= SIZE)
        DO
          INSERT INTO ping(name) VALUES ('ping');
          INSERT INTO ping(name) VALUES ('pong');
          SET i = i + 1;
        END WHILE;
 END $$
 DELIMITER ;
	DELIMITER $$
	CREATE PROCEDURE LOADGEN(SIZE INT)
	DETERMINISTIC
	READS SQL DATA
	BEGIN
	DECLARE i INT unsigned DEFAULT 1;
	WHILE (i <= SIZE)
	DO
	INSERT INTO ping(name) VALUES ('ping');
	INSERT INTO ping(name) VALUES ('pong');
	SET i = i + 1;
	END WHILE;
	END $$
	DELIMITER ;