How to Rename a Field in a MySQL Table
To 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.
ALTER TABLE mytable CHANGE oldname newname VARCHAR(32);
Comments are currently closed.