Interested to Buy Any Domain ? << Click Here >> for more details...
How can we change the name of a column of a table?
- 7 Answers
- 10932 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 to return query output in html format?
How do I show users in mysql?
Write command to import an mysql file?
How does triggers work in mysql?
How to Set a root password if there is on root password.
What are the objects can be created using CREATE statement?
How to get a list of all tables in a database?
Does mysql support nosql?
How to write optimized query in mysql?
How can an index be declared in mysql?
Can I use mariadb instead of mysql?
Explain the difference between primary key and candidate key in mysql?
What is offset limit?
all the queries used in sql
What is limit in mysql?
