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`;
Be The First To Comment
Related Post
Please Leave Your Comments Below