> data points. I don't want duplicate entries, mostly due to sections of > the log accidentally being uploaded twice. I am currently doing a
Ok, so it is EXACTLY the same data that might be inserted twice? - Make a UNIQUE index for the relevant column(s) that uniquely identify a record. - Use "INSERT IGNORE ...." This way you will have no duplicates and no inserts will fail (MySQL will simply ignore duplicate entries) Hope this helps a bit. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]