You can use the remove()
method to delete some or all documents from a collection in a schema. The X DevAPI provides additional methods for use with the remove()
method to filter and sort the documents to be removed.
The following example passes a search condition to the remove()
method. All documents matching the condition are removed from the countryinfo
collection. In this example, one document matches the condition.
mysql-js> db.countryinfo.remove("Code = 'SEA'")
To remove the first document in the countryinfo
collection, use the limit()
method with a value of 1.
mysql-js> db.countryinfo.remove("true").limit(1)
The following example removes the last document in the countryinfo
collection by country name.
mysql-js> db.countryinfo.remove("true").sort(["Name desc"]).limit(1)
You can remove all documents in a collection. To do so, use the remove("true")
method without specifying a search condition.
Use care when you remove documents without specifying a search condition. This action deletes all documents from the collection.
Alternatively, use the db.drop_collection('countryinfo')
operation to delete the countryinfo
collection.
See CollectionRemoveFunction for the full syntax definition.
See Section 20.3.2, “Download and Import world_x Database” for instructions to recreate the world_x
schema.