On duplicate key update is a mariadb/mysql extension to the insert statement that, if it finds a duplicate unique or primary key, will instead perform an update. the row/s affected value is reported as 1 if a row is inserted, and 2 if a row is updated, unless the api's client_found_rows flag is set.. Using insert on duplicate key update. the alternative (and generally preferred) method for inserting into rows that may contain duplicate unique or primary key values is to use the insert on duplicate key update statement and clause.. Defaults and duplicate values. see insert - default & duplicate values for details.. insert ignore. see insert ignore. insert on duplicate key update. see insert on duplicate key update. examples. specifying the column names: insert into person (first_name, last_name) values ('john', 'doe'); inserting more than 1 row at a time:.
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.. 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. for example, with this table:. Mysql insert on duplicate key update eloquent trait. insert duplicate key update is a quick way to do mass insert.. it's a trait meant to be used with laravel's eloquent orm. code example.