【MongoDB】删除操作

戒掉贪嗔痴(薛双奇)

已于 2024-06-12 11:00:39 修改

阅读量187

点赞数 1

分类专栏：数据库运维-MongoDB 文章标签： mongodb 数据库

于 2024-06-12 10:58:53 首次发布

本文链接：https://blog.csdn.net/weixin_43346403/article/details/139620462

版权

数据库运维-MongoDB 专栏收录该内容

41 篇文章 0 订阅

订阅专栏

1.删除满足条件的记录

> db.users.remove({"Gender":"M"})
WriteResult({ "nRemoved" : 1 })
> db.users.find({"Gender":"M"})

以删除男生为例，删除后没用男生的记录。

--删除45岁的女生。
> db.users.find()
{ "_id" : ObjectId("666a5b45adc823c6544594dc"), "FName" : "Test User", "Age" : 45, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594dd"), "Name" : "Test User1", "Age" : 11, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594de"), "Name" : "Test User2", "Age" : 12, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594df"), "Name" : "Test User3", "Age" : 13, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594e0"), "Name" : "Test User4", "Age" : 14, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594e1"), "Name" : "Test User5", "Age" : 15, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594e2"), "Name" : "Test User6", "Age" : 16, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594e3"), "Name" : "Test User7", "Age" : 17, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594e4"), "Name" : "Test User8", "Age" : 18, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594e5"), "Name" : "Test User9", "Age" : 19, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594e6"), "Name" : "Test User10", "Age" : 20, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594e7"), "Name" : "Test User11", "Age" : 21, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594e8"), "Name" : "Test User12", "Age" : 22, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594e9"), "Name" : "Test User13", "Age" : 23, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594ea"), "Name" : "Test User14", "Age" : 24, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594eb"), "Name" : "Test User15", "Age" : 25, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594ec"), "Name" : "Test User16", "Age" : 26, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594ed"), "Name" : "Test User17", "Age" : 27, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594ee"), "Name" : "Test User18", "Age" : 28, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594ef"), "Name" : "Test User19", "Age" : 29, "Gender" : "F", "Country" : "UK" }
Type "it" for more
> db.users.remove({"FName" : "Test User", "Age" : 45, "Gender" : "F"})
WriteResult({ "nRemoved" : 1 })
> db.users.find()
{ "_id" : ObjectId("666a5b86adc823c6544594dd"), "Name" : "Test User1", "Age" : 11, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594de"), "Name" : "Test User2", "Age" : 12, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594df"), "Name" : "Test User3", "Age" : 13, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594e0"), "Name" : "Test User4", "Age" : 14, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594e1"), "Name" : "Test User5", "Age" : 15, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594e2"), "Name" : "Test User6", "Age" : 16, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594e3"), "Name" : "Test User7", "Age" : 17, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594e4"), "Name" : "Test User8", "Age" : 18, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594e5"), "Name" : "Test User9", "Age" : 19, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594e6"), "Name" : "Test User10", "Age" : 20, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594e7"), "Name" : "Test User11", "Age" : 21, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594e8"), "Name" : "Test User12", "Age" : 22, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594e9"), "Name" : "Test User13", "Age" : 23, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594ea"), "Name" : "Test User14", "Age" : 24, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594eb"), "Name" : "Test User15", "Age" : 25, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594ec"), "Name" : "Test User16", "Age" : 26, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594ed"), "Name" : "Test User17", "Age" : 27, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594ee"), "Name" : "Test User18", "Age" : 28, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594ef"), "Name" : "Test User19", "Age" : 29, "Gender" : "F", "Country" : "UK" }
{ "_id" : ObjectId("666a5b86adc823c6544594f0"), "Name" : "Test User20", "Age" : 30, "Gender" : "F", "Country" : "UK" }
Type "it" for more

2.执行truncate操作，删除所有的数据。

> db.users.remove();
2024-06-13T10:52:55.987+0800 E QUERY [js] Error: remove needs a query :
DBCollection.prototype._parseRemove@src/mongo/shell/collection.js:356:1
DBCollection.prototype.remove@src/mongo/shell/collection.js:383:18
@(shell):1:1
在Mongodb4.0.2的版本中，不允许不带任何参数执行删除。必须携带条件删除。

3.drop 集合

> db.users.drop()
true
> show collections;
drop命令可以删除整个集合。