MySQL/MariaDB parsing problem
I have a stored procedure created in an .sql file:
DROP PROCEDURE IF EXISTS sp_groups_saveGroup;
DELIMITER //
CREATE DEFINER = INVOKER
PROCEDURE sp_groups_saveGroup(
IN in_groupId INT UNSIGNED,
IN in_groupCode VARCHAR(32),
IN in_groupTitle VARCHAR(128),
IN in_description VARCHAR(255),
When I redirect it into MySql (MariaDB) on the command line, it works fine.
When I 'Execute' it within PHPStorm (PS-143-279) I get:
[2015-10-23 12:21:57] Run /Users/david/TasoMedia/utah/build/mysql/sprocs/groups/groups_saveGroup.sql [2015-10-23 12:21:57] Connecting to utah71... DROP PROCEDURE IF EXISTS sp_groups_saveGroup [2015-10-23 12:21:57] 0 row(s) affected in 1ms ms DELIMITER // [2015-10-23 12:21:57] [42000][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 'DELIMITER //' at line 1 CREATE DEFINER = INVOKER PROCEDURE sp_groups_saveGroup( IN in_groupId INT UNSIGNED, ...
Is this an EAP issue? Something to do with switching to MariaDB from Mysql? Can't fathom it myself.
Please sign in to leave a comment.