> > 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.
I think REPLACE INTO will work well for you. Use it the same as you would use INSERT INTO http://dev.mysql.com/doc/mysql/en/REPLACE.html olinux __________________________________ Do you Yahoo!? Vote for the stars of Yahoo!'s next ad campaign! http://advision.webevents.yahoo.com/yahoo/votelifeengine/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]