How to change tablename in MySQL?
There are certain situation when developer need to change the name of any table in database. In MySQL we have feature to change one table and mulitple table in one query. Below is the query to change table name
(1)Change single table in MySQL
Rename Old_Table_Name to New_Table_Name
(2)Change multiple table name in MySQL
Rename table Old_Table_Name to New_Table_name,Old_Table_Name2 to New_Table_Name2,Old_TableName3 to New_Table_Name3; | |