This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- SQL script error
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 26, 2007
01:23 AM
SQL script error
I have been trying to run a MySQL script using the Script options in InstallShiled.
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?
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?
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 26, 2007
10:03 AM
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.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 26, 2007
11:51 AM
Yes that worked!
Thanks alot!
Just for others refrence:
Change the Batch Seperator to ";" instead of "GO"
and align your statements this way
Thanks alot!
Just for others refrence:
Change the Batch Seperator to ";" instead of "GO"
and align your statements this way
statement1
;
statement2
;