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.
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.