Mysql on duplicate key update if statement

Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related 5. Hot Network Questions. Question feed. Improve this answer. Thank you very much for your help!

Also, the 'test' value was an oversight; this was a value that I was using for col2 when testing, and forgot to remove it. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. LIKE Statement. Silent Column Specification Changes.

Secondary Indexes and Generated Columns. Data Manipulation Statements. Parenthesized Query Expressions. The Subquery as Scalar Operand.

Comparisons Using Subqueries. Restrictions on Subqueries. Transactional and Locking Statements. Statements That Cause an Implicit Commit. Restrictions on XA Transactions. Replication Statements. Update the table first using update query and where clause b. If update fails then insert the record into table using insert query. Basically, the statement first tries to insert a new row into the table.

Because there is no duplicate, MySQL inserts a new row into the devices table. The statement above has the same effect as the following statement:.