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;

Example

rename mysql database table

See MySQL

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

Leave a Reply

Your email address will not be published. Required fields are marked *