1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Add Column - MySQL Command

By

Businesswoman in an office working on a laptop computer
Diane Diederich/E+/Getty Images
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.
Related Video
Windows Movie Maker Music
Top Related Searches
  • column name
    1. About.com
    2. Technology
    3. PHP / MySQL
    4. MySQL Commands
    5. Adding a Column in MySQL With the Add Column Command

    ©2014 About.com. All rights reserved.