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
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
[...] 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: [...]
By: How to change a database table name on January 23, 2008
at 9:27 pm
I think you missed something which is this sign ( ` ).
CMIIW.
thanks
By: dnrestcom on April 6, 2009
at 12:12 am
Thats not mandatory!
By: anshprat on April 13, 2009
at 12:59 pm