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

Then show us the sql schema. And btw please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial. — j0k
– j0k, Commented Dec 26, 2012 at 16:48
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 — Nrc
– Nrc, Commented Dec 26, 2012 at 16:48
Possible duplicate stackoverflow.com/questions/1655599/mysql-rename-column — Geo
– Geo, Commented Dec 26, 2012 at 17:03

Ravi · Accepted Answer · 2015-06-13 13:22:24Z

5

alter table tablename change oldColumn newColumn varchar(10) ;

Reference : Alter Table - MySQL Command

edited Jun 13, 2015 at 13:22

answered Dec 26, 2012 at 16:51

Ravi

31.6k44 gold badges124 silver badges180 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

OneMore · Accepted Answer · 2012-12-31 20:33:35Z

5

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

The MySQL documentation

edited Dec 31, 2012 at 20:33

OneMore

1,1792 gold badges9 silver badges20 bronze badges

answered Dec 26, 2012 at 16:48

Talha Akbar

10.1k7 gold badges41 silver badges62 bronze badges

2 Comments

Aaron W. Over a year ago

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

Talha Akbar Over a year ago

@AaronW. oh sorry i forgot it!

Collectives™ on Stack Overflow

Rename column name with php and MySql

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related