Is mongodb has the equivalent way of mysql's on duplicate key update?

Asked Sep 27 '21 at 07:54

Active Sep 27 '21 at 08:09

Viewed 70 times

Mysql can update the field with the new value and the exist value when the row exist like this,

insert into table (col1, col2) 
values (value1, value2) 
on duplicate key update 
col1 = col1 + values(col1);

Is mongodb has the equivalent way?

I just know the upsert option, which can only set the new value to the exist one. How to use the new value and exist value at the same time?

edited Sep 27 '21 at 08:09

Shadow

asked Sep 27 '21 at 07:54

LF00

Does this answer your question? [How to update a field using its previous value in MongoDB/Mongoose](https://stackoverflow.com/questions/43770216/how-to-update-a-field-using-its-previous-value-in-mongodb-mongoose) – eol Sep 27 '21 at 08:03
You can use : https://docs.mongodb.com/manual/reference/operator/update/setOnInsert/ – Ergest Basha Sep 27 '21 at 08:03
This might help: https://stackoverflow.com/questions/10059739/mongodb-insert-on-duplicate-key-update – Ergest Basha Sep 27 '21 at 08:04
@eol Here is not find and update. Here is update when insert. If the row not exist, it will insert it, and if exist, it will update it. – LF00 Sep 27 '21 at 08:54
You're right, nvm :) – eol Sep 27 '21 at 08:55
I think you can get that behavior using the `upsert` option. – Joe Sep 27 '21 at 19:16
@Joe how to the the old value in the `upsert` option. For example `value = preValue + newValue` – LF00 Sep 28 '21 at 01:27
The `$inc` operator does that – Joe Sep 28 '21 at 03:53
@Joe can you make it an anser. – LF00 Sep 28 '21 at 05:30

0 Answers0