CentOS 7 Shell 操作 MongoDB

最新推荐文章于 2024-06-13 11:21:53 发布

老实人张大傻

最新推荐文章于 2024-06-13 11:21:53 发布

阅读量552

点赞数

分类专栏： Linux 学习 MongoDB

本文链接：https://blog.csdn.net/u010766726/article/details/121671811

版权

MongoDB 查询删除状态筛选数据验证

关键词由CSDN通过智能技术生成

Linux 学习同时被 2 个专栏收录

92 篇文章 3 订阅

订阅专栏

MongoDB

11 篇文章 1 订阅

订阅专栏

文章目录

准备测试库

[dev@hessian01 ~]$ mongo --quiet 192.168.8.147:21234/zhanghq_test --authenticationDatabase zhanghq_test -u zhanghq -p 123456 --eval "db.inventory.find({ })"

{ "_id" : ObjectId("61a82c8cfc568e1535e2c22a"), "item" : "journal", "qty" : 25, "size" : { "h" : 14, "w" : 21, "uom" : "cm" }, "status" : "A" }
{ "_id" : ObjectId("61a82c8cfc568e1535e2c22b"), "item" : "notebook", "qty" : 50, "size" : { "h" : 8.5, "w" : 11, "uom" : "in" }, "status" : "P" }
{ "_id" : ObjectId("61a82c8cfc568e1535e2c22c"), "item" : "paper", "qty" : 100, "size" : { "h" : 8.5, "w" : 11, "uom" : "in" }, "status" : "D" }
{ "_id" : ObjectId("61a82c8cfc568e1535e2c22d"), "item" : "planner", "qty" : 75, "size" : { "h" : 22.85, "w" : 30, "uom" : "cm" }, "status" : "D" }
{ "_id" : ObjectId("61a82c8cfc568e1535e2c22e"), "item" : "postcard", "qty" : 45, "size" : { "h" : 10, "w" : 15.25, "uom" : "cm" }, "status" : "A" }

查看特定条件内容

[dev@hessian01 ~]$ mongo --quiet 192.168.8.147:21234/zhanghq_test --authenticationDatabase zhanghq_test -u zhanghq -p 123456 --eval "db.inventory.find({ status:'A' })"
{ "_id" : ObjectId("61a82c8cfc568e1535e2c22a"), "item" : "journal", "qty" : 25, "size" : { "h" : 14, "w" : 21, "uom" : "cm" }, "status" : "A" }
{ "_id" : ObjectId("61a82c8cfc568e1535e2c22e"), "item" : "postcard", "qty" : 45, "size" : { "h" : 10, "w" : 15.25, "uom" : "cm" }, "status" : "A" }

删除特定内容数据

[dev@hessian01 ~]$ mongo --quiet 192.168.8.147:21234/zhanghq_test --authenticationDatabase zhanghq_test -u zhanghq -p 123456 --eval "db.inventory.deleteMany({ status:'A' })"
{ "acknowledged" : true, "deletedCount" : 2 }

验证结果

[dev@hessian01 ~]$ mongo --quiet 192.168.8.147:21234/zhanghq_test --authenticationDatabase zhanghq_test -u zhanghq -p 123456 --eval "db.inventory.find({ })"
{ "_id" : ObjectId("61a82c8cfc568e1535e2c22b"), "item" : "notebook", "qty" : 50, "size" : { "h" : 8.5, "w" : 11, "uom" : "in" }, "status" : "P" }
{ "_id" : ObjectId("61a82c8cfc568e1535e2c22c"), "item" : "paper", "qty" : 100, "size" : { "h" : 8.5, "w" : 11, "uom" : "in" }, "status" : "D" }
{ "_id" : ObjectId("61a82c8cfc568e1535e2c22d"), "item" : "planner", "qty" : 75, "size" : { "h" : 22.85, "w" : 30, "uom" : "cm" }, "status" : "D" }