on 7/20/04 9:44 PM, Wesley Furgiuele at [EMAIL PROTECTED] wrote: > First off, the unique index is something you define for the table once. > Being unique, you won't be allowed to add in another record with the > same values as an record that already exists in the table.
I thought so, thanks. > And yes, once you set it up, INSERT IGNORE would allow your query to > simply skip the insertion of any records that already exist in the > table. Something else to look at would be the INSERT ... ON DUPLICATE > KEY UPDATE syntax, depending on your version of MySQL ( >= 4.1 ) > http://dev.mysql.com/doc/mysql/en/INSERT.html Super, so the INSERT IGNORE is gonna work. Curious why you pointed me to the ON DUPLICATE KEY link. Since I want to just gracefully exit from the insert, I assume you were just pointing this out as a FYI? This feature is more or less if I wanted to make some update to a row when the duplicate was hit? > I'm not yet sure yet what to make of your last situation, where you are > merging addresses into one group. About the bounce count, presumably > that is not necessarily the same value for each instance of an email > address across different groups? Is the bounce count the only field > that would differ between the two duplicate records? To be honest, I am not entirely sure, yet, this will require me to ponder some more about how this is going to work. Thanks for all your help so far, this is a great solution to a otherwise complicated to me issue :-) -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
