Getting Error When Creating An Sp

[Bijoy Chacko]

The following is the code that I am trying to execute, line to line, character to character and spaces to spaces

---

DELIMITER $$

CREATE PROCEDURE testing()

BEGIN

select * from test1;

END$$

DELIMITER;

---

I am getting this following error

---

Error Code : 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 'DELIMITER $$

CREATE PROCEDURE testing()

BEGIN

select * from test1' at line 1

(0 ms taken)

Error Code : 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 'END$$

DELIMITER' at line 1

(0 ms taken)

---

Please help 🙁

[peterlaursen]

I believe that the HTML encoding removes some spaces-

You have (when I copy)

Quote:

DELIMITER $$

CREATE PROCEDURE testing()

BEGIN

select * from test1;

END$$

DELIMITER;

Please try to remove the leading spaces. I can reproduce it with the leading spaces. But not if I remove them. If this is the problem it is a bug with the SQLyog 'tokenizer'.

Alos please tell what program version you are using. 9.33 or 9.4 beta. This is important for us to know.

[peterlaursen]

OK .. verifed.

If DELIMITER -keyword does not start on first postion in the editor it causes a tokenizer failure (the 'tokenizer' is the code that identifes where a statement starts and stops basically).

I have added this to our issue-tracker here: http://code.google.com/p/sqlyog/issues/detail?id=1739

[Author]

Posts