You can use the remove()
method to delete
some or all documents from a collection in a database. The
X DevAPI provides additional methods for use with the
remove()
method to filter and sort the
documents to be removed.
The example that follows passes a search condition to the
remove()
method. All documents matching the
condition will be removed from the countryinfo collection. In
this example, one document matches the condition.
mysql-js> db.countryinfo.remove("_id = 'SEA'")
Query OK, 1 item affected (0.02 sec)
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)
Query OK, 1 item affected (0.03 sec)
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)
Query OK, 1 item affected (0.02 sec)
You can remove all documents in a collection. To do so, use
the remove("true")
method without
specifying any search condition.
Use care when you remove documents without specifying a search condition. This action will delete all documents from the collection.
See CollectionRemoveFunction for the full syntax definition.
See Section 19.4.2, “Import Database Sample” for instructions to recreate the
world_x
database.