Menu
For testing, is it possible to run a loop from MySQL workbench or similar tool? I tried but got an error.
If it is possible, please supply a simple example I can run.
761
You can also create functions in MYSQL. Similar to other programming languages MySQL provides support for the flow control statements such as IF, CASE, ITERATE, LEAVE LOOP, WHILE, and REPEAT. You can use these statements in the stored programs (procedures), and RETURN in stored functions.
The LOOP statement allows you to execute one or more statements repeatedly. The LOOP can have optional labels at the beginning and end of the block. The LOOP executes the statement_list repeatedly. The statement_list may have one or more statements, each terminated by a semicolon (;) statement delimiter.
You can't do a for loop in an SQL editor without a stored procedure. I use TOAD for MySQL.
A quick stored procedure should do the job:
DELIMITER $$ DROP PROCEDURE IF EXISTS proc_loop_test$$ CREATE PROCEDURE proc_loop_test() BEGIN DECLARE int_val INT DEFAULT 0; test_loop : LOOP IF (int_val = 10) THEN LEAVE test_loop; END IF; SET int_val = int_val +1; SELECT int_val; END LOOP; END$$ DELIMITER ; If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
