Re: [Phpmyadmin-devel] How to execute a multi query?

On Wed, 2011-05-25 at 16:32 +0200, Michal Čihař wrote:

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.

OMG, you're right, that worked just fine! And I just spend like 3 hours trying to figure out the delimiter business...

Thanks Michal, that was most helpful.

Rouslan