I am not certain from the documentation whether it is advisable to create a unique multi-column index on two columns that are already individually indexed. The individual indexes I assume I need for when I do a SELECT on those particular columns. The multi-column one I need for the reasons discussed below. Any one know?
Thanks, John on 7/7/04 2:21 PM, Joshua J. Kugler at [EMAIL PROTECTED] wrote: > Certainly, it's called making a unique index on the field(s) you want to keep > unique. > > Hope that helps. > > j----- k----- > > On Wednesday 07 July 2004 12:48 pm, John Mistler said something like: >> Is there a way to do an INSERT on a table only if no row already exists >> with the same info for one or more of the columns as the row to be >> inserted? That is, without using a method outside SQL? >> >> Thanks, >> >> John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]