Re: Setting A MySQL Column to NO DUPLICATES

I'm not sure if you can... What I usually do is do a query to see if there's already an entry there, and display an error message if there is. Another thing to you can do is allow duplicate entries, and use the DISTINCT option in the SELECT statement. This wouldnt be as efficient, so i'd try the query check first. If there is a way to disallow duplicates, i'd love to know. Jason "Jeff Gannaway" <webmaster@cactusgraphics.com> wrote in message news:200110252132.f9PLWoh29767@cactusgraphics.cactusgraphics.com... > 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 > ___________________________________________________________ >