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