cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
omairmoh
Level 3

SQL script error

I have been trying to run a MySQL script using the Script options in InstallShiled.

CREATE TABLE `actions` (
`Id` int(11) NOT NULL default '0',
`name` varchar(100) NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

CREATE TABLE `ae_action_rules` (
`action_id` int(10) unsigned NOT NULL,
`rule_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`action_id`,`rule_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


Thats the script, What I get is SQL syntax error. I have tried replacing the ";" with a /, GO, ; on a new line etc.
But doesnt seem to work.

What am I doing wrong here?
Labels (1)
0 Kudos
(2) Replies
hidenori
Level 17

Please change the batch separator from GO to ; using the Connection | Advanced tab in the SQL Scripts view and see if it solves the issue.
0 Kudos
omairmoh
Level 3

Yes that worked!
Thanks alot!
Just for others refrence:
Change the Batch Seperator to ";" instead of "GO"
and align your statements this way
statement1
;
statement2
;
0 Kudos