10 Apr, 2009 in MySQL by admin

Add Column – MySQL Command

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 [table name] 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.

Bookmark This

No Responses so far | Have Your Say!

Leave a Feedback

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>