Re: Setting A MySQL Column to NO DUPLICATES

are you trying to have one column not be a dup or a combination of columns? jim ----- Original Message ----- From: "Jeff Gannaway" <webmaster@cactusgraphics.com> To: <php-general@lists.php.net> Sent: Thursday, October 25, 2001 2:31 PM Subject: [PHP] Setting A MySQL Column to NO DUPLICATES > 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 wish their site was a good > as PHP.net. > > Later, > Jeff Ganaway > ___________________________________________________________ > > Save 15% on 2002 Calendars and Holiday Cards! > > http://www.AvantGifts.com > Discount Code: hopper22ct > Offer Good Through October 31, 2001 > ___________________________________________________________ > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >