Interested to Buy Any Domain ? << Click Here >> for more details...
How can we change the name of a column of a table?
- 7 Answers
- 10624 Views
- I also Faced
- E-Mail Answers
Answer Posted / chaithra.t
ALTER TABLE tablename RENAME COLUMN old_columnname TO
new_columnname;
above is to change the column name of the table.
In case if u want to change the table name then:
ALTER TABLE tablename RENAME TO new_tablename;
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
How important is to list the column names when doing an insert?
How to copy data from one server to another using php?
What does mysql flush tables do?
What are the features of mysql?
What do you understand by mysql terminal?
How do you connect MySQL database with PHP?
What are the difference between and myisam and innodb?
How do I insert an image into mysql workbench?
What command is used to delete the data from the table without deleting the table structure?
What is mysql installer?
How can we get the number of rows affected by query?
What is the maximum number of columns per table?
How does mysql clustering work?
What is a left join mysql?
What is the role of a limit in a mysql query?
