1. Computing
Send to a Friend via Email

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

©2014 About.com. All rights reserved.