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)
Subject
Views
Written By
Posted
1681
April 16, 2012 01:24PM
Re: Forward Engineering Data Modeling Design Causes Error
729
April 18, 2012 10:12AM
555
April 18, 2012 10:28AM
762
April 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.