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 <[email protected]> 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 : [email protected] > Unsubscribe : https://launchpad.net/~maria-developers > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
