Add or delete columns in a table in MySQL
Monday, March 17th, 2008Add a column to a table in the database:
ALTER TABLE table_name
ADD column_name datatype
Delete a column from a table in the database:
ALTER TABLE table_name
DROP COLUMN column_name