Re: Setting A MySQL Column to NO DUPLICATES

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 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