Gossamer Forum
(Advanced Search)
for
Home : General : Perl Programming :

MySQL AutoIncrement

Nov 13, 2001, 12:25 PM
Paul
Veteran (19537 posts)
Nov 13, 2001, 12:25 PM
Post #1 of 2
Views: 2124
Shortcut
Quote Reply
MySQL AutoIncrement
If you set a column to auto-increment is it really necessary to set it as unique also or will auto-increment not allow duplicates?
Nov 13, 2001, 2:09 PM
brewt
Staff (4101 posts)
brewt's avatar
Nov 13, 2001, 2:09 PM
Post #2 of 2
Views: 2054
Shortcut
Quote Reply
Re: [RedRum] MySQL AutoIncrement In reply to
When you define a field as auto_increment, it has to be primary key (so then it won't allow duplicates, unless of course you define more than one primary key).


Adrian