on 7/20/04 10:06 PM, Wesley Furgiuele at [EMAIL PROTECTED] wrote: > Scott: > > Yeah, exactly. The ON DUPLICATE KEY is useful if your table has > something like a "last modified" or "last accessed" column that is > relevant for what you're doing. It is just an easier way to accomplish > INSERT IGNORE plus then doing an UPDATE on all the rows that got > ignored, in case you need to document that there was an attempt to > insert the data.
Thanks, this is indeed nice to know, if ever there was a good reason to update mysql, this is it, I can see this coming in handy in the future a whole lot. -- ------------------------------------------------------------- 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]