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
Advertisement
Add a comment

Leave a Reply

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

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Advertisement