Add 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
Tags: alter, MySQL, sql, tables
Filed under MySQL.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.