Create a unique index on each column that you don't want to be duplicated. create UNIQUE index table_u1 on table(some_column)
--- John Mistler <[EMAIL PROTECTED]> wrote: > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]