Skip navigation links

MySQL Forums :: Newbie :: alter table .... add constraint


Advanced Search

Re: alter table .... add constraint
Posted by: REMI VERVECKEN ()
Date: April 16, 2012 01:29AM

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

Options: ReplyQuote


Subject Written By Posted
alter table .... add constraint REMI VERVECKEN 04/15/2012 08:50AM
Re: alter table .... add constraint Peter Brawley 04/15/2012 09:51AM
Re: alter table .... add constraint REMI VERVECKEN 04/15/2012 11:17AM
Re: alter table .... add constraint Peter Brawley 04/15/2012 02:22PM
Re: alter table .... add constraint REMI VERVECKEN 04/16/2012 01:29AM
Re: alter table .... add constraint Peter Brawley 04/16/2012 07:56AM
Re: alter table .... add constraint REMI VERVECKEN 04/16/2012 08:33AM
Re: alter table .... add constraint REMI VERVECKEN 04/16/2012 10:00AM
Re: alter table .... add constraint Vinood Chuhan 04/17/2012 03:08AM
Re: alter table .... add constraint REMI VERVECKEN 04/17/2012 07:46AM
Re: alter table .... add constraint REMI VERVECKEN 04/17/2012 07:51AM


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.