Re: alter table .... add constraint
giving apply on your comment, I got following result:
mysql> alter table licenses
-> add constraint FK_1
-> foreign key (FK_OS)
-> referemces OS (idOS);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'refer
emces OS (idOS)' at line 4
mysql>
on basic of this error message I change the order, which gave me the result as shown before.
-------------------------------------------------
Computer Technology Support & Consulting
www.ctsc.de
Subject
Written By
Posted
Re: alter table .... add constraint
April 16, 2012 08:33AM
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.