In MongoDB the db.collection.findOneAndUpdate() method updates a single document based on the filter and sort criteria.
The collection part is the name of the collection with which to perform the operation against.
what is
MongoDB findAndModify()
In MongoDB the db.collection.findAndModify() method modifies and returns a single document.
The collection part is the name of the collection with which to perform the operation against.
MongoDB updateMany()
In MongoDB the db.collection.updateMany() method updates all documents that match the specified filter for a collection.
MongoDB update()
In MongoDB the db.collection.update() method modifies an existing document or documents in a collection.
By default, it only updates a single document. But if multi: true is specified, then it updates all documents that match the query criteria.
MongoDB updateOne()
In MongoDB the db.collection.updateOne() method updates a single document within the collection based on the filter.
MongoDB insert()
In MongoDB the db.collection.insert() method inserts a document or documents into a collection.
The collection part is the name of the collection to insert the document/s into.
MongoDB insertMany()
In MongoDB the db.collection.insertMany() method inserts multiple documents into a collection.
The collection part is the name of the collection to insert the documents into.
MongoDB insertOne()
In MongoDB the db.collection.insertOne() method inserts a single document into a collection.
The collection part is the name of the collection to insert the document into.
MongoDB Upsert Explained
Many update operations in MongoDB have the potential to be upserts. An upsert is a combination of an insert and an update.
It works like this: You perform an update operation based on filter criteria, and if there are any matches, only the matched documents are updated, but if there are no matches, then a new document is inserted.
SQL ALTER TABLE for Beginners
In SQL, the ALTER TABLE statement modifies the definition of an existing table.
You can use ALTER TABLE to alter, add, or drop columns and constraints.
Depending on your DBMS, the ALTER TABLE statement can also be used to reassign and rebuild partitions, or disable and enable constraints and triggers.