Rename column name with php and MySql

Question

I am trying to change the name of the column c to novaC with php and mysql. Everywhere I look seems to give the same solution but it doesn't seem to work:

if(isset($_GET["rename"])){
    mysql_query("ALTER TABLE myTable
    RENAME COLUMN c to novaC");
}

If I type: ALTER TABLE aaa RENAME COLUMN c to novaC directly in MySql it gives:

 #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLUMN c to novaC' at line 2

Solution 1

alter table tablename change oldColumn newColumn varchar(10) ; 

Reference : Alter Table - MySQL Command

Solution 2

if(isset($_GET["rename"])){ 
    mysql_query("ALTER TABLE myTable CHANGE c  novaC varchar(9999)"); 
}

The MySQL documentation

Comments

[Aaron W.]

The CHANGE requires you to specify the "column_definition" as well. So that query would cause an error.

[Nrc]

This is perfect. Thank you.

[Muhammad Talha Akbar]

@AaronW. oh sorry i forgot it!