I was wondering if it is possible to perform a 'quiet' insert in MySQL.
Here is what I mean by a 'quiet' insert.
if row with ID 1 already exists in a table, then its value should be updated using UPDATE TABLE, otherwise it should be added using INSERT INTO
It is possible to perform a SELECT to see if the row exists and then to do an UPADTE or INSERT based on the results but it seems like a non-efficient way to do it.
Is there a way to do it in a single command?
The command will update the table if the row already exists, or insert it otherwise