Skip to content

MySQL - While do procedure example

Just a small example of how write a procedure / function in mysql (5.x) by using a simple while loop for inserting (example testdata) into a database.

DROP PROCEDURE IF EXISTS doWhileArtodeto; DELIMITER // CREATE PROCEDURE doWhileArtodeto() BEGIN DECLARE int1 INT DEFAULT 1; DECLARE int2 INT DEFAULT 50; int1loop: WHILE int1 <= int2 DO INSERT INTO `my_db`.`my_table` (`name`,`value`) VALUES('artodeto',int1); SET v1 = int1 + 1; END WHILE int1loop; END// DELIMITER ; CALL doWhileArtodeto(); DROP PROCEDURE doWhileArtodeto;

Feel free to use. It should be self explanatory, if not, do not use it (remember, you should always know what code you copy and what you do).

If you want to know more, try the following links. Procedure tutorial Manual about while on


No Trackbacks


Display comments as Linear | Threaded

No comments

Add Comment

E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
To leave a comment you must approve it via e-mail, which will be sent to your address after submission.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.

Markdown format allowed
Form options