database - Error renaming a column in MySQL

Question

How do I rename a column in table xyz? The columns are:

Manufacurerid, name, status, AI, PK, int

I want to rename to manufacturerid

I tried using PHPMyAdmin panel, but I get this error:

MySQL said: Documentation
#1025 - Error on rename of '.shopping#sql-c98_26' to '.shoppingblmanufacturer' (errno: 150)

Answer 1

Lone Ranger is very close... in fact, you also need to specify the datatype of the renamed column. For example:

ALTER TABLE `xyz` CHANGE `manufacurerid` `manufacturerid` INT;

Remember :

• Replace INT with whatever your column data type is (REQUIRED)
• Tilde/ Backtick (`) is optional