The on duplicate key update clause can contain multiple column assignments, separated by commas. in assignment value expressions in the on duplicate key update clause, you can use the values(col_name) function to refer to column values from the insert portion of the insert on duplicate key update statement.. Your table definition says 'on duplicate key update', however your key is auto-incrementing and so, unless you explicitly try to insert into the id field, the key will never be a duplicate. (1,2,3) is not the key, and is therefore not duplicate – mark sinkinson aug 12 '15 at 12:35. It means that all code after on duplicate key update won't be executed. for instance in our example when we don't have such values in database, after this query we will have row with article_id = 12 and views_count = 1 (not 2). batch insert with on duplicate key. there is also option to make batch insert to database using on duplicate key update..
Can you update and elaborate on: what happens if other (not duplicate key violations) errors occur? and how does this work exactly (what 1062 stand for)? does the query need to be a singe insert or can it work with inserting multiple rows? – ypercubeᵀᴹ apr 17 '17 at 23:10. Use mysql’s non-standard on duplicate key update extension to accomplish the insert and update in a single step. as with the non-standard insert ignore above, this is probably the fastest method: insert into t1(a, b, c) select d, e, f from t2 on duplicate key update b = e, c = f;. Conditional duplicate key updates with mysql. when updating summary tables we typically use on duplicate key update, a mysql extension to insert statements since version 4.1, that allows a record to either be inserted or updated in one query. (11) unsigned not null, last_event_created_at datetime not null, primary key.