Question

How to implement WHILE LOOP with IF STATEMENT MySQL?

Answer 1

WHILE loop. The WHILE loop checks the expression at the beginning of each iteration. If the expression evaluates to TRUE , MySQL will execute statements between WHILE and END WHILE until the expression evaluates to FALSE .