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

开发者_StackOverflowIs it possible to rename a MySQL table? If so, how?

---

You can use RENAME TABLE

RENAME TABLE `foo` TO `bar`;

or ALTER TABLE

ALTER TABLE `foo` RENAME TO `bar`;

---

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.