alter table .... add constraint
Don't know if I am wrong, or there some big issue in MySQL 5.6.
in anyway (sql workbench, sql developper, terminal client) giving following statement:
alter table licenses
add CONSTRAINT FK_OS_LIC
FOREIGN KEY (FK_OS)
REFERENCES os (OS );
result in following message:
(terminal client)
ERROR 1005 (HY000): Can't create table 'mydb.#sql-7d0_a' (errno: 150)
(sql developer)
SQL-Fehler: Can't create table 'mydb.#sql-7d0_1d' (errno: 150)
anyone an idea, what is going wrong?
-------------------------------------------------
Computer Technology Support & Consulting
www.ctsc.de
Subject
Written By
Posted
alter table .... add constraint
April 15, 2012 08:50AM
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.