In MySQL, I have this following stored procedure along with a For loop in it:
CREATE PROCEDURE ABC()
DECLARE a INT Default 0 ;
IF a=5 THEN
END LOOP simple_loop;
It is always printing "1". What is the correct syntax for the for loop in MySQL?