Ответ

max_rip 06.07.2011 11:22 / 06.07.2011 11:23

INSERT INTO test (id,val1,val2) VALUES (1,1,1),(2,2,3),(3,9,3),(4,10,12),(5,10,12),(6,10,12),(7,5,12),(8,10,12)
ON DUPLICATE KEY UPDATE val1=VALUES(val1),val2=VALUES(val2);