update
Update one or multiple documents in MongoDB collection
The update
function will be removed in a future release. Use the
update
function of the MongoDB® C++ interface instead.
Description
returns the number of documents updated in a collection using the MongoDB connection. Use MongoDB queries to find and update documents.n
= update(conn
,collection
,findquery
,updatequery
)
Examples
Update Documents in Collection
Connect to MongoDB and update documents in a collection. Find documents to update by using a MongoDB query. Specify the criteria for the update by using a MongoDB query. Here, the collection represents employee data.
Create a MongoDB connection to the database mongotest
. Here, the database server dbtb01
hosts this database using port number 27017
.
server = "dbtb01"; port = 27017; dbname = "mongotest"; conn = mongo(server,port,dbname)
conn = mongo with properties: Database: 'mongotest' UserName: '' Server: {'dbtb01'} Port: 27017 CollectionNames: {'airlinesmall', 'employee', 'largedata' ... and 3 more} TotalDocuments: 23485919
conn
is the
mongo
object that contains the MongoDB connection. The object properties contain information about the connection and the
database.
The database name is
mongotest
.The user name is blank.
The database server is
dbtb01
.The port number is
27017
.This database contains six document collections. The first three collection names are
airlinesmall
,employee
, andlargedata
.This database contains 23,485,919 documents.
Verify the MongoDB connection.
isopen(conn)
ans = logical 1
The database connection is successful because the isopen
function returns 1
. Otherwise, the database connection is closed.
Specify the employee
collection. Create a MongoDB query to find employees in the Sales department. Then, create
a MongoDB query to increase the value in the salary
field by 5000.
collection = "employee"; findquery = '{"department":"Sales"}'; updatequery = '{$inc:{"salary":5000}}';
Increase the salaries for all employees in the Sales department using the
MongoDB connection. The update
function updates
seven documents in the collection.
n = update(conn,collection,findquery,updatequery)
n = 7
Close the MongoDB connection.
close(conn)
Input Arguments
conn
— MongoDB connection
mongo
object
MongoDB connection, specified as a mongo
object.
collection
— Collection name
string scalar
Collection name, specified as a string scalar.
Example: "taxidata"
Data Types: string
findquery
— MongoDB find query
string scalar | character vector
MongoDB find query, specified as a string scalar or character vector. Specify a JSON-style string to find documents in the database.
Example: '{"department":"Sales"}'
finds all documents
where the department
field is equal to
Sales
.
Example: '{"_id":{$oid:"593fec95b78dc311e01e9204"}}'
finds the document that has the identifier
593fec95b78dc311e01e9204
.
Data Types: char
| string
updatequery
— MongoDB update query
string scalar | character vector
MongoDB update query, specified as a string scalar or character vector. Use a JSON-style string to specify the criteria for the update.
Example: '{$inc:{"salary":5000}}'
increases the values
in the salary
field by
5000
.
Data Types: char
| string
Output Arguments
n
— Number of documents updated
numeric scalar
Number of documents updated in a collection in the database, returned as a numeric scalar.
Version History
MATLAB Command
You clicked a link that corresponds to this MATLAB command:
Run the command by entering it in the MATLAB Command Window. Web browsers do not support MATLAB commands.
Select a Web Site
Choose a web site to get translated content where available and see local events and offers. Based on your location, we recommend that you select: .
You can also select a web site from the following list:
How to Get Best Site Performance
Select the China site (in Chinese or English) for best site performance. Other MathWorks country sites are not optimized for visits from your location.
Americas
- América Latina (Español)
- Canada (English)
- United States (English)
Europe
- Belgium (English)
- Denmark (English)
- Deutschland (Deutsch)
- España (Español)
- Finland (English)
- France (Français)
- Ireland (English)
- Italia (Italiano)
- Luxembourg (English)
- Netherlands (English)
- Norway (English)
- Österreich (Deutsch)
- Portugal (English)
- Sweden (English)
- Switzerland
- United Kingdom (English)