Insert ignore doesn't insert the record if there is a duplicate. It simply doesn't insert the row. Without the IGNORE clause, the query would generate an error insert of silenty ignoring the insert.
--- [EMAIL PROTECTED] wrote: > That's the whole point. Eliminate your indexes and > your load problems are > solved. Especially given the fact that you insert > ignore and don't use the > primary key to validate uniqueness. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
