subject:"\[PHP\] Setting A MySQL Column to NO DUPLICATES"

Re: [PHP] Setting A MySQL Column to NO DUPLICATES

2001-10-25 Thread Jim Lucas

are you trying to have one column not be a dup or a combination of columns? jim - Original Message - From: "Jeff Gannaway" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 25, 2001 2:31 PM Subject: [PHP] Setting A MySQL Column to NO DUPLICATES

Re: [PHP] Setting A MySQL Column to NO DUPLICATES

2001-10-25 Thread Steve Cayford

I think you want UNIQUE. create table sometable ( somecolumn char(40), someothercolum int, unique somecolumn ) ...something like that. I haven't messed with it much. -Steve On Thursday, October 25, 2001, at 04:31 PM, Jeff Gannaway wrote: > Does anyone know how to set

[PHP] Setting A MySQL Column to NO DUPLICATES

2001-10-25 Thread Jeff Gannaway

Does anyone know how to set a column in a MySQL table to disallow any duplicate entries. I've already got a PRIMARY KEY defined for this table. I tried setting the other field to a MUL KEY, hoping that it would not permit duplicates, but it does. I've searched the MySQL docs without success. I