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

You should accept the answer, because it's correct.

Adrian
– Adrian

2012-06-08 14:43:36 +00:00
Commented Jun 8, 2012 at 14:43 — Adrian
– Adrian, Commented Jun 8, 2012 at 14:43

John Flatness · Accepted Answer · 2011-09-13 20:37:14Z

67

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 ;

answered Sep 13, 2011 at 20:37

John Flatness

34.1k5 gold badges81 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Toseef Zafar Over a year ago

this should be marked as answer, thanks John Flatness

Derek · Accepted Answer · 2011-09-13 20:35:00Z

-4

Remove the DECLARE, you should be able to just do this:

SET @x = 0;

Also, variables need to be prefixed with the @ symbol

answered Sep 13, 2011 at 20:35

Derek

23.5k8 gold badges55 silver badges61 bronze badges

3 Comments

redolent Over a year ago

Unrelated to the question, but this really helped me.

skiwi Over a year ago

This will create variables that are visible to the whole session, you just want to declare them as then they are visible only inside the stored procedure.

Rahnzo Over a year ago

Agree with Skiwi.. this is a real bad answer.

Collectives™ on Stack Overflow

syntax error for mysql declaration of variable

2 Answers 2

1 Comment

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related