Knowledge for the World

Rename a MySQL table

Renaming a MySQL table is very simple, but sometimes the syntax is hard to remember.

1

In the MySQL prompt type: use database_name

2

Now type: RENAME TABLE old_table_name TO new_table_name;