1. Computing & Technology

Discuss in my forum

Add Column - MySQL Command

By , About.com Guide

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] [type];
Also Known As: Add Column, Additional Column, New Column
Examples:
alter table icecream add column flavor varchar (20) ; 
This would add the column "flavor" to the table "icecream". It would be in varchar (20) format.
Related Searches column name