Printed from

MySQL rename a table or column

Summary: As of MySQL 5.0, renaming a table is trivial with the "rename table" function. Renaming a column was a little cryptic, even looking at the documentation. Here are a couple of concrete examples.

To rename a table from "lu_wind_direction" to "lu_direction":

mysql> rename table lu_wind_direction to lu_direction;

To rename a column called "wind_direction_id" to "direction_id" in the table named "spacetime":

mysql> alter table spacetime change wind_direction_id direction_id tinyint(3) unsigned;

So, when renaming a column, it's just the original name first, then after the new name, you need to include the column specifications and constraints.


CC License Ubuntu OpenOffice GIMP Graphics Geany Editor Firefox Play Ogg what's this?