How to rename a MySQL database table

Written by Yujin Boby

Edit in WordPress

To rename a MySQL database table, login to phpMyAdmin or MySQL command line, then select the database, run following SQL command

ALTER TABLE TABLE_OLD_NAME RENAME TO TABLE_NEW_NAME;

Example

rename mysql database table

See MySQL