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.. On duplicate key update inserts or updates a row, the last_insert_id() function returns the auto_increment value. the on duplicate key update clause can contain multiple column assignments, separated by commas.. On duplicate key update skips auto_increment values" didn't make it into 5.0.36 and 5.1.16, so we need to adjust the bug-detection-based-on-version-number code..
I am using mysql version 5.0.36 and trying to insert on duplicate key update and getting unexpected results. i have detailed the unexpected behavior below.. On duplicate key update to update multiple records we know by using insert command we can add records, but by using same insert command we can update multiple records of a table. in our student table we have one unique auto increment field as id. here we can't have two records with same id. mysql. php. javascript.. Noted in 5.0.38, 5.1.17 changelogs. an insert on duplicate key update statement might modify values in a table but not flush affected data from the query cache, causing subsequent selects to return stale results. this made the combination of query cache plus on duplicate key update very unreliable..
