Jump to content

Archived

This topic is now archived and is closed to further replies.

johnnyk

MySQL UNIQUE

Recommended Posts

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.

Share this post


Link to post
Share on other sites
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?

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
[!--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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.