UPDATE if present; else INSERT

Question

I want to update a record, which may or may not be in the table. If it is not in the database, it will be inserted.

To prevent selection, I first use the operator UPDATEand check affected_rows > 0if not, then I insert this record into the table.

I was wondering if there is a better way to do this?

Answer 1

You can use the syntax INSERT ... ON DUPLICATE KEY UPDATE:

INSERT INTO table (a,b,c) VALUES (1,2,3)
  ON DUPLICATE KEY UPDATE c=c+1;

http://dev.mysql.com/doc/refman/4.1/en/insert-on-duplicate.html

---

REPLACE ( Femaref) , REPLACE , , , .

Answer 2

Replace Insert.

http://dev.mysql.com/doc/refman/5.0/en/replace.html