Rename MySQL table - Change MySQL table name:

Database or website admin work sometimes asks for simple tasks like renaming a mysql table.

Say you have a mysql database named test and, inside it, you have the following 3 tables:

$ mysql -u root -ppassword test Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 11342 Server version: 5.0.45-log FreeBSD port: mysql-server-5.0.45_1 Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> show tables; +----------------+ | Tables_in_test | +----------------+ | Table_test1 | | Table_test2 | | Table_test3 | +----------------+ 3 rows in set (0.00 sec) mysql>

and you want to change the name of Table_test1's table into new_table. This is done by using using the mysql rename table syntax: RENAME TABLE old_table TO new_table

mysql> RENAME TABLE Table_test1 TO new_table; Query OK, 0 rows affected (0.00 sec) mysql> show tables; +----------------+ | Tables_in_test | +----------------+ | new_table | | Table_test2 | | Table_test3 | +----------------+ 3 rows in set (0.00 sec)

As you can see the query for changing the table's name was successful.

Rename more than one MySQL table

Renaming more than one Mysql table is very similar in structure to changing the name of only one table. This query looks like this:

RENAME TABLE this_table TO that_table, old_table TO this_table;

Bookmarks:

Echo "MySQL table - change or rename MySql table name" around:

-------------------advertising-----------------