Hi Dne Wed, 25 May 2011 15:19:52 +0100 Rouslan Placella <rouslan@placella.com> napsal(a):
Yes, I am generating the query on the fly, but I'm not sure how I am supposed to split it. Here's a simple example that I don't know how to handle:
CREATE PROCEDURE `proc`(INOUT p INT(10)) BEGIN SELECT 10 into p; END//
If I first try to execute
DELIMITER //
then PMA_DBI_query straight away returns the following error:
ERROR: Unknown Punctuation String @ 11 STR: // SQL: DELIMITER //
Thanks again for any help with this.
You don't have to split it at all in this case :-). DELIMITER is not handled by server for single query, so all you have to do is to issue: CREATE PROCEDURE `proc`(INOUT p INT(10)) BEGIN SELECT 10 into p; END For displaying purposes, DELIMITER statement might be added, so that user can copy and paste the query. -- Michal Čihař | http://cihar.com | http://blog.cihar.com