How to rename an existing column in a table?



How to rename an existing column in a table?..

Answer / Puneet Tikkha

To rename an existing column in a MySQL table, you can use the ALTER TABLE statement. Here's an example:n`nALTER TABLE YourTable RENAME COLUMN old_column_name TO new_column_name;n`

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How would you backup and restore a big MySQL database? What are the advantages of the approach which you have taken over the others?

4 Answers  


What language is used in mysql?

1 Answers  


What does "i_am_a_dummy flag" do in mysql?

1 Answers  


Is mysql distributed?

1 Answers  


What does do in mysql?

1 Answers  


What is database in php mysql?

1 Answers  


what is JOIN? Give example & types of join?

14 Answers   iMedia, Millennium, RAM Software, Satyam,


How can you import tables from a sql file into a database by using the mysql client?

1 Answers  


What is the difference between timestamp and datetime in mysql?

1 Answers  


What is mysql in dbms?

1 Answers  


How to execute mysql query in php?

1 Answers  


Explain Normalization concept?

2 Answers   Inuva,


Categories