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 |
How would you backup and restore a big MySQL database? What are the advantages of the approach which you have taken over the others?
What language is used in mysql?
What does "i_am_a_dummy flag" do in mysql?
Is mysql distributed?
What does do in mysql?
What is database in php mysql?
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?
What is the difference between timestamp and datetime in mysql?
What is mysql in dbms?
How to execute mysql query in php?
Explain Normalization concept?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)