Mar 022009
How to rename table in MySQL
Answer:
Login into MySQL shell, and enter the following SQL
mysql> USE my_db;
mysql> RENAME TABLE old_table TO new_table;
Query OK, 0 rows affected (0.00 sec)
That's all what you need.
Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.
How to rename table in MySQL
Answer:
Login into MySQL shell, and enter the following SQL
mysql> USE my_db;
mysql> RENAME TABLE old_table TO new_table;
Query OK, 0 rows affected (0.00 sec)
That's all what you need.
