List:General Discussion« Previous MessageNext Message »
From:<vancouverhg Date:November 29 2005 11:16pm
Subject:RE: SQLquery: delimiter // - #1064 error
View as plain text  
HI David,

The following error is generated calling the previously defined stored
procedure p0() in phpmyadmin:
SQL query: 
call p0(
MySQL said:  

#1312 - PROCEDURE tr.p0 can't return a result set in the given context 

Any suggestions would be greatly appreciated

-----Original Message-----
From: Logan, David (SST - Adelaide) [mailto:David.Logan@stripped] 
Sent: Tuesday, November 29, 2005 2:59 PM
To: Dave Kennedy; mysql@stripped
Subject: RE: SQLquery: delimiter // - #1064 error 

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


David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000

+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax

-----Original Message-----
From: Dave Kennedy [mailto:vancouverhg@stripped] 
Sent: Wednesday, 30 November 2005 9:25 AM
To: mysql@stripped
Subject: SQLquery: delimiter // - #1064 error 

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

MySQL General Mailing List
For list archives:
To unsubscribe:

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