Difference between revisions of "MongoDB Delete"
From mi-linux
Jump to navigationJump to searchLine 25: | Line 25: | ||
</pre> | </pre> | ||
+ | |||
+ | This is equivalent to the SQL command: | ||
+ | |||
+ | <pre style="color: blue"> | ||
+ | DROP TABLE emp; | ||
+ | </pre> | ||
== Delete Department 40 == | == Delete Department 40 == |
Revision as of 17:02, 12 November 2017
Main Page >> MongoDB >>MongoDB Workbook >> Deleting a Document/Collection
Deleting a Document
At some stage you may want to delete a document from a collection. The format is:
db.collectionName.deleteOne(query_criteria) /* deletes the first document found that matches the query criteria */
db.collectionName.remove(query_criteria) /* deletes all documents found that matches the query criteria */
db.collectionName.remove(query_criteria) /* deletes all documents in a collection (use with care!) */
Deleting a Collection
If you want to drop a collection completely, including any data held in it:
db.collectionName.drop() /* removes a collection completely (use with care!) */
This is equivalent to the SQL command:
DROP TABLE emp;
Delete Department 40
Department 40 has closed down:
db.dept.deleteOne({deptno:40})
Note, if the query_criteria only returns one document, remove() and deleteOne() will have the same effect.
Check that the collection has gone:
db.dept.find({deptno:40})
Next Step
This concludes the section on manipulating collections. Return to the Workbook.