Upsert

What is UPSERT and how to do it in MySQL
UPSERT allows the Data Manipulation Language (DML's) author to insert a new row or update an existing row. UPSERT is an atomic operation meaning it is...