1. Computing

Discuss in my forum

Add Unique - MySQL Command

By , About.com Guide

Definition: When you are altering a table to add in another colum you can use Add Unique. This will add in a new column, and make sure that it's not a duplicate of any of the already existing columns. It is written as: alter table your_table add unique (column_name)
Also Known As: Add Unique Column
Examples:
alter table people add unique (eye_color)
This code would add a new column, eye_color, to the table called people - if that column didn't already exist.
Related Video
Add Sound to PowerPoint
Add Video to Your MySpace Page
Top Related Searches alter table column name colum eye color
  1. About.com
  2. Computing
  3. PHP / MySQL
  4. MySQL Commands
  5. SQL Add Unique - Add Unique Table Column MySQL

©2013 About.com. All rights reserved.