How can we change the name of a column of a table?

Answer Posted / owais masood

RENAME cannot be used to change the column name, however, it
is used to change the table or database name. However the
CHANGE is used to to rename a column with the su=yntax given
above by vipul (Answer 2)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mysql57?

512


Explain timestamp?

591


What does it mean to be case sensitive?

477


What is mysql enterprise edition?

460


How to update info already in a table and delete a row(s) from a table.

457






what is the difference between between and in operators in mysql?

505


What is insert query in mysql?

477


How do I restore a mysql database?

542


What is difference between mysql_connect and mysql_pconnect?

557


What is root password?

477


What is a tinyint?

513


What is delimiter in mysql?

483


What is the default password for mysql?

466


How you will Show unique records.

548


How do I change a procedure in mysql?

491