Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
The article contains information about the while loop in MySQL and its usage.
While Loop in MySQL
The while loop, which is one of the loops used in programming languages, is used for repetitive operations according to a condition.
1 2 3 | WHILE MyCondition DO -- Commands END WHILE; |
An example of using a while loop in a stored procedure is as follows.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | DELIMITER // CREATE PROCEDURE while_loop(IN number INT, INOUT result TEXT) BEGIN DECLARE x INT; SET x = 1; WHILE x <= result DO SET result = CONCAT(result, x, ','); SET x = x + 1; END WHILE; END // DELIMITER ; |
Let’s run the stored procedure.
1 2 3 | SET @result= ''; CALL while_loop(10, @result); SELECT @result; |
When we run the stored procedure, numbers 1 to 10 will be written in a comma separated form.
Have a good days.
I want to store rows from a table in an array in MySQL. for example
select * from emp into arrayvariable.
then I want use the MySQL while loop to process each row individually .
Any help?