UNIQUE Constraints

 < Day Day Up > 

UNIQUE Constraints

When you specify a UNIQUE constraint for a column, MySQL generates an index (UNIQUE) and blocks any attempts to enter or update data so that more than one row has the same value in that column. If you attempt to duplicate a value, you receive an error:

 Duplicate entry 'Late check-in' for key 1 

     < Day Day Up > 


    MySQL Database Design and Tuning
    MySQL Database Design and Tuning
    ISBN: 0672327651
    EAN: 2147483647
    Year: 2005
    Pages: 131

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net