Posted by: h4ck@lyst | December 14, 2007

change table names in phpMyAdmin

Select the database that contains the table you want to edit. Then click on the “SQL” tab at the top of the page and run this query

RENAME TABLE tbl_name TO new_tbl_name



  1. […] There’s no obvious way to do this in PhpMyAdmin. I had expected an edit icon that would let me change the table name, but I guess that would be too simple. I did some digging and found the answer: […]

  2. I think you missed something which is this sign ( ` ).



    • Thats not mandatory! 🙂

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s


%d bloggers like this: