Re: Access Migration SQL error 1064
Thanks for your response! The error report was coming from MySQL workbench 6.3...4?
But, I did figure out the problem. For some reason it didn't like the comment after INDEX `{80503C8F-1844-4E52-BC34-935DF141BFBB}` (`VialID` ASC) COMMENT '',
INDEX `VialID` (`VialID` ASC) COMMENT '',
So I deleted the COMMENT '' to make it look like this:
INDEX `{80503C8F-1844-4E52-BC34-935DF141BFBB}` (`VialID` ASC),
INDEX `VialID` (`VialID` ASC),
And locked the edited scripts that were automatically produced by MySQL workbench.
It had no problem with the previous COMMENT '' commands, so I left those.
The rest of the import steps worked (mostly).
Subject
Written By
Posted
Re: Access Migration SQL error 1064
June 25, 2015 03:02PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.