mysqlsqlalter-tablemysql-error-1025

ALTER TABLE error

Can someone explain to me why I am receiving the following error?

I want to rename the column "exerciseID" to "ID" in a mysql table using the following syntax.

ALTER TABLE  `exercises` CHANGE  `exerciseID`  `ID` INT( 11 ) NOT NULL AUTO_INCREMENT

However I receive the following error:

MySQL said: 

#1025 - Error on rename of './balance/#sql-de_110e' to './balance/exercises' (errno: 150)

Any suggestions would be much appreciated

Solution

  • I would check to see if you have any foreign key references to that column. If so, you may need to remove the foreign relationships that you have defined for that column, then rename, then place your foreign key relationships back in place with the new column name.

    I think MySQL is getting hung up on the fact that when you rename, the FK relationships are no longer valid and it is throwing an error.

    EDIT: Confirmed FK Rename in MySQL

    You will need to do something like this: 

    alter table yourTable drop foreign key yourID