How to rename MySQL table?
The designing and development of any software system is a continuous process and you might give a wrong name to a table. After a review you many have to change the name of database. The MySQL database provide appropriate sql command to change the database name.
The alter table <table name> rename <new table name> command can be used to rename the table.
Suppose you have a table called called account and now you have to change it to loan_account then you can use the following command to change the table name.
alter table account rename loan_account;
The above command will rename the table account to loan_account.
Posted on: July 12, 2010 If you enjoyed this post then why not add us on Google+? Add us to your Circles