DELIMITERs are (should be) definitely handled in the client. The server does not know about it. It is also not listed here http://dev.mysql.com/doc/refman/5.6/en/sql-syntax.html for same reason. -- Peter On Tue, Feb 24, 2015 at 3:05 AM, Daniel Black <daniel.black@openquery.com> wrote:
----- Original Message -----
Manually executing the command result in this error : ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'USE mysql; DELIMITER //; CREATE PROCEDURE debian_plugin_install(IN plugin_name C' at line 1 150223 22:44:06 [ERROR] Aborting
By adding \n between each of these statements we can see that the statement causing the syntax error is "DELIMITER //;", it seems that DELIMITER is only used by mysql client and the that mysqld doesnt recognize it as an internal command.
thank you
-- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise & maintenance for MySQL/MariaDB server environments.
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp