The syntax on duplicate key update is for mysql, not ms-access. please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem.. 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).. 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..
Msaccess 2010 to mysql 5.5 "insert on duplicate key update" example could someone help me to find a way how to insert/update the contents of a table in access 2010 to mysql server 5.5 table ? the table has thousands of records so it also needs to be efficient.. Trying to avoid separate queries to check for key existance and then inserting or updating accordingly. from googling around it seems that access doesn't support sql server's merge either. thanks. On duplicate key update", and i could certainly use this for something i'm working on. however, i do not use mysql, only access and ms sql. is there a working equivalent for this statement in access or ms sql?.
