WHILE Statement

Allows SQL statements to be repeated.

Syntax

WHILE condition statement

Syntax Elements

condition
An SQL Search Condition.

statement
A supported SQL statement, or a group of statements enclosed in the BEGIN and END keywords.

Operation

While condition evaluates to true, the WHILE statement executes statement repeatedly.

Example

SET @I = 0

SET @V1 = SECOND(CURTIME())+1

WHILE @I<10

BEGIN

    SET @I = @I+1

    SET @V2 = @V1*@I + @V1/@I

    INSERT INTO TESTDATA VALUES(@I,@V2)

END

Loops, executing the block of three statements for each value of variable @I. The loop terminates when @I becomes equal to 10.

See Also

BREAK statement, CONTINUE statement.