Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
phpMyAdmin won't accept delimiter statement? What am I doing wrong?
I am working in phpMyAdmin v2.8.0.1 with a MySql 5.0.91 database. It's a brand new database, so there's nothing in it.
I click on the SQL tab, then enter this one line:
-----> delimiter //
(without the -----> of course). When I click on GO, it replies:
ERROR: Unknown Punctuation String @ 11
STR: //
SQL: delimiter //
According to all the manuals, this should work, but it doesn't. What am I doing wrong here? Or what is it I don't know? All help is appreciated.
I have discovered that the delimiter statement is unique to the MySql command line. Does anyone know a workaround in phpMyAdmin? I'm trying to create a stored procedure that contains multiple statements terminated by semi-colons.
Dear Colinc,
As stated in the previous additional details, I am trying to create a stored procedure that contains a compound statement. Because the compound statement necessarily contains semi-colons, those semi-colons terminate the SET PROCEDURE statement prematurely. Changing the delimiter to something else would resolve this problem, which is why I posed this question.
As for using //, this causes no problem with the file system because my stored procedure has nothing to do with the file system. It gets changed back to a semi-colon at the end of the CREATE PROCEDURE block, so again no problem.
1 Answer
- Anonymous9 years agoFavorite Answer
Do NOT mess with delimiters. There is absolutely no need to do this. The standard delimiters work for all normal use, and a lot of query languages will fall down totally if they see unknown delimiters. And using / as a delimiter when EVERY file system NEVER mess with default settings without good reason.