syntax error for mysql declaration of variable

Question

CREATE PROCEDURE dorepeat(IN p1 INT) BEGIN   DECLARE x INT DEFAULT 0;   REPEAT SET x = x + 1; UNTIL x > p1 END REPEAT; END 

I get an syntax error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for > the right syntax to use near '' at line 3

But for me, everything seems to be correct. i really don't have any clue! can anybody help?

thanks

Answer 1

You need to temporarily change the delimiter so the MySQL client doesn't think you're done with your statement when it sees the semicolon on line 3:

DELIMITER //  CREATE PROCEDURE dorepeat(IN p1 INT) BEGIN   DECLARE x INT DEFAULT 0;   REPEAT SET x = x + 1; UNTIL x > p1 END REPEAT; END//  DELIMITER ;