How to rename a MySQL database table

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;

1	ALTER TABLE TABLE_OLD_NAME RENAME TO TABLE_NEW_NAME;

Example

rename mysql database table

Need help with Linux Server or WordPress? We can help!