maria-developers team mailing list archive

[Peter Laursen <peter_laursen@xxxxxxxxxx>]

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@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-developers
> More help   : https://help.launchpad.net/ListHelp
>