Insert into a table or update if exists MySQL

by

DUPLICATE KEY can be used to DUPLICATE to Insert into a table or update if exists in MySQL.

INSERT INTO tableName (id, name, age) 
VALUES(10, "Roy", 34) 
ON DUPLICATE KEY 
UPDATE    
name="Roy", age=34

It will insert a new record if no record exists with id = 10, Otherwise update if any record exists with id = 10;