Jump to content

MySQL UNIQUE


johnnyk

Recommended Posts

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?
Link to comment
https://forums.phpfreaks.com/topic/12892-mysql-unique/#findComment-49783
Share on other sites

Archived

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

×
×
  • Create New...

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.