Hi Dave, The DELIMITER statement is a command to the mysql client not an SQL statement. This is why phpAdmin is objecting. Here are a listing of the mysql client commands
http://dev.mysql.com/doc/refman/5.0/en/mysql-commands.html Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -----Original Message----- From: Dave Kennedy [mailto:[EMAIL PROTECTED] Sent: Wednesday, 30 November 2005 9:25 AM To: mysql@lists.mysql.com Subject: SQLquery: delimiter // - #1064 error Windows XP phpMyAdmin 2.7.0-rc1 MySQL 5.0.16-nt running on localhost as [EMAIL PROTECTED] The DELIMITER statement works in the command line, but not in phpmyadmin (see error below) mysql> DELIMITER // mysql> use mysql // Database changed mysql> PHPmyadmin ======================= DELIMITER // Error 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
