Setting A MySQL Column to NO DUPLICATES

From: Date: Thu, 25 Oct 2001 21:31:00 +0000
Subject: Setting A MySQL Column to NO DUPLICATES
Groups: php.general 
Request: Send a blank email to php-general+get-72352@lists.php.net to get a copy of this message
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 ___________________________________________________________

« previous php.general (#72352) next »