Movatterモバイル変換

MySQL 8.0 Reference Manual

22.3.3.5 Remove Documents

You can use theremove() method to delete some or all documents from a collection in a schema. The X DevAPI provides additional methods for use with theremove() method to filter and sort the documents to be removed.

Remove Documents Using Conditions

The following example passes a search condition to theremove() method. All documents matching the condition are removed from thecountryinfo collection. In this example, one document matches the condition.

mysql-js> db.countryinfo.remove("Code = 'SEA'")

Remove the First Document

To remove the first document in thecountryinfo collection, use thelimit() method with a value of 1.

mysql-js> db.countryinfo.remove("true").limit(1)

Remove the Last Document in an Order

The following example removes the last document in thecountryinfo collection by country name.

mysql-js> db.countryinfo.remove("true").sort(["Name desc"]).limit(1)

Remove All Documents in a Collection

You can remove all documents in a collection. To do so, use theremove("true") method without specifying a search condition.

Caution

Use care when you remove documents without specifying a search condition. This action deletes all documents from the collection.

Alternatively, use thedb.drop_collection('countryinfo') operation to delete thecountryinfo collection.

Related Information

SeeCollectionRemoveFunction for the full syntax definition.
SeeSection 22.3.2, “Download and Import world_x Database” for instructions to recreate theworld_x schema.

PREV HOME UP NEXT