How to Rename a Field in a MySQL Table
How to Rename a Field in a MySQL Table
27 July , 2011 No Comments on How to Rename a Field in a MySQL TableTo change the name of a field in a MySQL database table use the CHANGE keyword with ALTER TABLE. You must also supply the field type again or you can change that too in the same line.
Example:
ALTER TABLE mytable CHANGE oldname newname VARCHAR(32);
Leave a comment