How To Rename an Existing Table in MySQL?

Answer

If you want to rename an existing table, you can use the "ALTER TABLE ... RENAME TO" statement. The tutorial script below shows you a good example:

mysql> ALTER TABLE test RENAME TO wb;
Query OK, 0 rows affected (0.01 sec)