13Mar/100
MySQL: How to add column to existing table
Definition: Add column is used to add an additional column to any given table. You must specify the column name, and type. It is written as alter table add column [new column name]
Examples:
ALTER TABLE `tablename_here` ADD `new_column_name` VARCHAR( 255 ) NOT NULL ;
or
ALTER TABLE `tablename_here` ADD `new_column_name` INT NOT NULL AFTER `existing_column`;