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 show all tables with 'mysql'?
What is a string in mysql?
What are mysql functions?
What is blob and text in mysql?
What is the date format in mysql?
Is null in mysql?
What is dump in mysql?
How to display top 10 rows in mysql?
Is mysql is a programming language?
How to enter numeric values as hex numbers?
What is pdo connection?
Why we use mysql workbench?
How do I copy a table in mysql workbench?
Can not connect to mysql server 10060?
What is required to create mysql database?