MySQL UNIQUE

[johnnyk]

What's the difference between UNIQUE and PRIMARY KEY?

[Barand]

A table can have only one PRIMARY KEY and it is always UNIQUE.

You can also have several other indexes which may be UNIQUE or not.

[johnnyk]

So if I just need one unique column, should I use primary key?
Also, I saw a tutorial online that defined one column as primary key and unique id. It looks like this:
[code]create table myBlobs
(
blobId int auto_increment not null,
blobTitle varchar(50),
blobData longblob,
blobType varchar(50),
primary key(blobId),
unique id(blobId)
);[/code]
[a href=\"http://www.devarticles.com/c/a/MySQL/Blobbing-Data-With-PHP-and-MySQL/1/\" target=\"_blank\"]http://www.devarticles.com/c/a/MySQL/Blobb...HP-and-MySQL/1/[/a]

Why would they define it as primary key and unique?

[Barand]

Because they don't know what they are doing.

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]So if I just need one unique column, should I use primary key?[/quote]
Yes

[johnnyk]

[!--quoteo(post=388209:date=Jun 26 2006, 04:44 PM:name=Barand)--][div class=\'quotetop\']QUOTE(Barand @ Jun 26 2006, 04:44 PM) [snapback]388209[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Because they don't know what they are doing.
[/quote]
Hah. Alright, thanks.