Mysql remove column from an existing table
The following command will remove an existing table's specified column and the data contained:
mysql> ALTER TABLE table_name DROP column_name;
As with any database/file delete/edit actions, it's recommended to have a backup. You never know when you meight need it.