To delete a column in a MySQL database column, use the DROP COLUMN keywords with ALTER TABLE. Do not mistake deleting a field for deleting a record.

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. Example: ALTER TABLE mytable CHANGE oldname newname VARCHAR(32);