1. Computing

Add Unique - MySQL Command

By

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
  1. About.com
  2. Computing
  3. PHP / MySQL
  4. MySQL Commands
  5. SQL Add Unique - Add Unique Table Column MySQL

©2014 About.com. All rights reserved.