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

About these ads

Responses

  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 ( ` ).

    CMIIW.

    thanks

    • Thats not mandatory! :)


Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Categories

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: