Is it possible to rename a MySQL table name already in the database?

Question

Is it possible to rename a MySQL table? If so, how?

Answer 1

You can use RENAME TABLE

RENAME TABLE `foo` TO `bar`;

or ALTER TABLE

ALTER TABLE `foo` RENAME TO `bar`;

Answer 2

If you're using MySQL Query Browser, you can just right-click on the table, select Edit Table and change the Table Name field and apply the changes.