ALTER TABLE error
- by Travis
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…