Interested to Buy Any Domain ? << Click Here >> for more details...
How can we change the name of a column of a table?
- 7 Answers
- 10836 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
Is mysql a framework?
How many primary keys can be there in a table?
What is meant by sharding?
How many columns can be used for creating Index?
Do you need a license for mysql?
How to create a table index in mysql?
What is inner join in mysql?
What is mysql optimization?
What is the full form of mysql?
What is a text delimiter?
How to get last inserted id after insert data from a table in mysql?
What is the difference between a heap table and temporary table?
What is definer in mysql?
Why do we write stored procedures?
What is striped backup
