Insert into a MySQL table or update if exists

QUERY:

INSERT INTO table (id, name, age) VALUES(1, "A", 19) ON DUPLICATE KEY UPDATE    name="A", age=19

mysql sql insert-update upsert

Check out REPLACE

REPLACE into table (id, name, age) values(1, "A", 19)

mysql sql insert-update upsert

When using batch insert use the following syntax:

INSERT INTO TABLE (id, name, age) VALUES (1, "A", 19), (2, "B", 17), (3, "C", 22)ON DUPLICATE KEY UPDATE    name = VALUES (name),    ...

CodeHunter