Thank you for your fast reply! On Wed, Oct 7, 2009 at 6:25 PM, ewen fortune <ewen.fort...@gmail.com> wrote: > Why not use INSERT ON DUPLICATE KEY UPDATE. > http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html > >> So, If I want to insert-update the record "(a1,b2),b3" the two cases would >> be: >> >> a) record "(a1,a2),a3" exists and has a matching "a1" >> --update-to--> "(a1,b2),b3" >> b) there doesn't exist any record matching a1 >> ----insert---> "(a1,b2),a3" > > So, > > INSERT INTO table (a,b,c) VALUES (1,2,3) > ON DUPLICATE KEY UPDATE b=2,c=3;
That has the same effect as REPLACE for me. The primary key is "a,b" so, it's possible that there's a (1,4,5) record already in the table that I want updated but INSERT ON DUPLICATE KEY UPDATE will instead insert a (1,2,3) record (the "a" field is the same but it still has a different "b" and thus it's a different primary key, so it's not considered a duplicate). -- Fernando -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org