MySQL Forums
Forum List  »  MySQL Workbench

Re: Forward Engineering Data Modeling Design Causes Error
Posted by: Rick James
Date: April 18, 2012 10:12AM

We need a flashing neon sign telling Newbies that 1064 always points exactly at the problem. In your case:
> ... syntax to use near ') , PRIMARY KEY (`Training_Key`) , ...

Compare that to
> ... INDEX `Training_Key` () , PRIMARY KEY (`Training_Key`) , ...
Then check the syntax to discover that INDEX needs something inside the parentheses.

Also, since a PRIMARY KEY is an INDEX, it would be redundant if you had
INDEX(Training_Key)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Forward Engineering Data Modeling Design Causes Error
554
April 18, 2012 10:12AM


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.