List:General Discussion« Previous MessageNext Message »
From:Dave Kennedy Date:November 29 2005 10:55pm
Subject:SQLquery: delimiter // - #1064 error
View as plain text  
Windows XP
phpMyAdmin 2.7.0-rc1
MySQL 5.0.16-nt running on localhost as root@localhost

The DELIMITER statement works in the command line, but not in phpmyadmin 
(see error below)

mysql> DELIMITER //
mysql> use mysql //
Database changed

PHPmyadmin =======================

There seems to be an error in your SQL query. The MySQL server error output 
below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 11
STR: //
SQL: delimiter //

SQL query:
delimiter //

MySQL said:

#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 //' at line 1

SQLquery: delimiter // - #1064 errorDave Kennedy29 Nov
RE: SQLquery: delimiter // - #1064 errorSST - Adelaide)29 Nov
  • RE: SQLquery: delimiter // - #1064 errorvancouverhg30 Nov
Re: SQLquery: delimiter // - #1064 errorPeter Brawley30 Nov