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.