xxxxxxxxxx
/*UNDER THE HOOD THIS IS A DELETE, YOU NEED TO INSERT ALL FIELDS*/
REPLACE INTO table1 (id, name, age) VALUES(1, "A", 19)
/*THIS IS THE TURE INSERT OR UPDATE*/
INSERT INTO table1 (id, name, age) VALUES(1, "A", 19) ON DUPLICATE KEY UPDATE name="A", age=19
xxxxxxxxxx
INSERT INTO TABLE (id, name, age) VALUES (1, "A", 19), (2, "B", 17), (3, "C", 22)
ON DUPLICATE KEY UPDATE
name = VALUES (name),