Re: alter table return error

Michael Stassen wrote: Did you try perror? ~: perror 150 Error code 150: Unknown error: 150 150 = Foreign key constraint is incorrectly formed Right, I forgot to alter one table that had a FK on this table. Thanks ;) -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For l

Re: alter table return error

Did you try perror? ~: perror 150 Error code 150: Unknown error: 150 150 = Foreign key constraint is incorrectly formed Michael Philippe Poelvoorde wrote: Hi, I'm trying to add an 'unsigned' attribute to one column : > alter table markets modify Id integer unsigned not null auto_increment;

alter table return error

Hi, I'm trying to add an 'unsigned' attribute to one column : > alter table markets modify Id integer unsigned not null auto_increment; ERROR 1025: Error on rename of './eurex_dax/#sql-1d2c_2f' to './eurex_dax/markets' (errno: 150) The query runs without any problems on any others tables (all are