Skip navigation links

MySQL Forums :: MySQL Workbench :: Forward Engineering Data Modeling Design Causes Error


Advanced Search

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
Forward Engineering Data Modeling Design Causes Error 1009 Russell Simmons 04/16/2012 01:24PM
Re: Forward Engineering Data Modeling Design Causes Error 431 Rick James 04/18/2012 10:12AM
Re: Forward Engineering Data Modeling Design Causes Error 376 Russell Simmons 04/18/2012 10:28AM
Re: Forward Engineering Data Modeling Design Causes Error 498 Mike Lischke 04/20/2012 02:18AM


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.