The statement above sets the value of the c1 to its current value specified by the expression values(c1) plus 1 if there is a duplicate in unique index or primary key. mysql insert on duplicate key update example. let’s take a look at an example of using the insert on duplicate key update to understand how it works.. 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.. If you specify on duplicate key update, and a row is inserted that would cause a duplicate value in a unique index or primary key, mysql performs an update of the old row. for example, if column a is declared as unique and contains the value 1, the following two statements have similar effect:.
No comments:
Post a Comment