Cry MySQL How to...

Rename a database table

To rename a MySQL database table use:

alter table old_table_name rename to new_table_name

where 'old_table_name' is the original name of the table and 'new_table_name' is the desired new name.

These notes have been tested against MySQL version 5.1, and may apply to other versions as well.

About the author: Brian Cryer is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.