采用
INSERT ... ON DUPLICATE KEY UPDATE
查询:
INSERT INTO table (id, name, age) VALUES(1, "A", 19) ON DUPLICATE KEY UPDATE name="A", age=19

采用
INSERT ... ON DUPLICATE KEY UPDATE
查询:
INSERT INTO table (id, name, age) VALUES(1, "A", 19) ON DUPLICATE KEY UPDATE name="A", age=19