Re: alter table .... add constraint
changed FK_OS in table licenses to INT and altered the table for a constraint with following result:
mysql> alter table licenses
-> add constraint FK_1
-> foreign key (FK_OS)
-> references idOS (OS);
ERROR 1005 (HY000): Can't create table 'mydb.#sql-7d0_3f' (errno: 150)
I am getting really frustated at these trivial things.
-------------------------------------------------
Computer Technology Support & Consulting
www.ctsc.de
Subject
Written By
Posted
Re: alter table .... add constraint
April 16, 2012 01:29AM
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.