1. Home
  2. Computing & Technology
  3. PHP / MySQL

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 [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.
Explore PHP / MySQL
About.com Special Features

Holiday Central

What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

  1. Home
  2. Computing & Technology
  3. PHP / MySQL
  4. MySQL Commands
  5. Add Column - SQL Add Column - MySQL Add Column

©2009 About.com, a part of The New York Times Company.

All rights reserved.