All pastes #2051445 Raw Edit

Mine

public text v1 · immutable
#2051445 ·published 2011-04-28 07:08 UTC
rendered paste body
INSERT INTO table1 SELECT * from table2 ON DUPLICATE KEY UPDATE 
        f4 = IF(table1.f4 < VALUES(f4),VALUES(f4),table1.f4),
        f6 = IF(table1.f4 < VALUES(f4),VALUES(s6),table1.s6),
        f7 = IF(table1.f4 < VALUES(f4),VALUES(f7),table1.f7),
        ts = IF(table1.f4 < VALUES(f4),VALUES(ts),table1.ts)
;