Summary: in this tutorial, you will learn how to use the MySQL REPEAT statement to execute one or more statements until a search condition is true.

The REPEAT statement executes one or more statements until a search condition is true.

Here is the basic syntax of the REPEAT loop statement:

Code language: SQL (Structured Query Language) (sql)

The REPEAT executes the statement until the search_condition evaluates to true.

The REPEAT checks the search_condition after the execution of statement, therefore, the statement always executes at least once. This is why the REPEAT is also known as a post-test loop.

The REPEAT statement can have labels at the beginning and at the end. These labels are optional.

The following flowchart illustrates the REPEAT loop:

MySQL REPEAT loop example

This statement creates a stored procedure called RepeatDemo  that uses the REPEAT statement to concatenate numbers from 1 to 9:

Code language: SQL (Structured Query Language) (sql)

In this stored procedure:

First, declare two variables counter and result and set their initial values to 1 and blank.

The counter variable is used for counting from 1 to 9 in the loop. And the result variable is used for storing the concatenated string after each loop iteration.

Second, append counter value to the result variable using the CONCAT() function until the counter is greater than or equal to 10.

The following statement calls the RepeatDemo() stored procedure:

Code language: SQL (Structured Query Language) (sql)

Here is the output:

Code language: SQL (Structured Query Language) (sql)

In this tutorial, you will learn how to use the MySQL REPEAT statement to execute one or more statement until a search condition is true.