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)
;