Hi
Dne Wed, 25 May 2011 14:35:44 +0100
Rouslan Placella <rouslan(a)placella.com> napsal(a):
I can't find anywhere a method for changing the
delimiter for a query,
so that I can manipulate stored routines. For example, trying to
execute:
DELIMITER //
SELECT NOW()//
with PMA_DBI_query() fails with a syntax error, yet I can change the
delimiter in the SQL tab, in the input box below the textarea. But it
looks like the queries typed into the SQL tab are executed by
import.php.
Yes, import.php is responsible for splitting input into multiple
queries and they are run separately by PMA_DBI_query. So if you need to
split out query, you have to go through import.php.
However if you are generating the query, you should send it part by
part using PMA_DBI_query and just set sql_query to show complete query
in the user interface.
--
Michal Čihař |
http://cihar.com |
http://blog.cihar.com