Thread: Unique index across multiple fields
View Single Post
Old 03-06-2013, 03:58 PM   PM User | #10
Old Pedant
Supreme Master coder!

 
Old Pedant's Avatar
 
Join Date: Feb 2009
Posts: 23,200
Thanks: 59
Thanked 3,996 Times in 3,965 Posts
Old Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to all
Quote:
Originally Posted by Arcticwarrio View Post
cant you just add a column that is auto increment?
How will that help him detect that the 4 fields he NEEDS to be unique actually are unique? All that would do is ensure that he doesn't duplicate the auto increment column. Kind of useless for his purposes.
__________________
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.
Old Pedant is offline   Reply With Quote