当前位置:Gxlcms > 数据库问题 > MongoDB的删除操作

MongoDB的删除操作

时间:2021-07-01 10:21:17 帮助过:24人阅读

show dbs admin 0.000GB config 0.000GB local 0.000GB sdata 0.000GB test 0.000GB > use sdata switched to db sdata > db.dropDatabase() { "dropped" : "sdata", "ok" : 1 } > show dbs admin 0.000GB config 0.000GB local 0.000GB test 0.000GB

 

2.删除集合   集合删除语法格式如下:
  db.collection.drop()

  1. <span style="color: #808080;">></span> <span style="color: #0000ff;">use</span><span style="color: #000000;"> test
  2. switched </span><span style="color: #0000ff;">to</span><span style="color: #000000;"> db test
  3. </span><span style="color: #808080;">></span><span style="color: #000000;"> db
  4. test
  5. </span><span style="color: #808080;">></span><span style="color: #000000;"> show tables
  6. firstCollection
  7. user_info
  8. </span><span style="color: #808080;">></span> db.firstCollection.<span style="color: #0000ff;">drop</span><span style="color: #000000;">()
  9. true
  10. </span><span style="color: #808080;">></span><span style="color: #000000;"> show tables
  11. user_info</span>

 

3.删除文档数据

db.collection.remove(
   <query>,
   {
     justOne: <boolean>,
     writeConcern: <document>
   }
)

参数说明:
query :(可选)删除的文档的条件。
justOne : (可选)如果设为 true 或 1,则只删除一个文档,如果不设置该参数,或使用默认值 false,则删除所有匹配条件的文档。
writeConcern :(可选)抛出异常的级别。

  1. <span style="color: #808080;">></span><span style="color: #000000;"> show tables
  2. user_info
  3. </span><span style="color: #808080;">></span><span style="color: #000000;"> db.user_info.find()
  4. { "_id" : ObjectId("5de47393fc0c5f2c5c98a979"), "name" : "zhangsan", "age" : "</span><span style="color: #800000; font-weight: bold;">23</span><span style="color: #000000;">", "adrss" : "zhenzhou" }
  5. </span><span style="color: #808080;">></span>
  6. <span style="color: #808080;">></span> db.user_info.<span style="color: #0000ff;">insert</span>({name:<span style="color: #ff0000;">‘</span><span style="color: #ff0000;">wangwu</span><span style="color: #ff0000;">‘</span>,age:<span style="color: #ff0000;">‘</span><span style="color: #ff0000;">12</span><span style="color: #ff0000;">‘</span>,adress:<span style="color: #ff0000;">‘</span><span style="color: #ff0000;">shanghai</span><span style="color: #ff0000;">‘</span><span style="color: #000000;">})
  7. WriteResult({ "nInserted" : </span><span style="color: #800000; font-weight: bold;">1</span><span style="color: #000000;"> })
  8. </span><span style="color: #808080;">></span><span style="color: #000000;"> db.user_info.find()
  9. { "_id" : ObjectId("5de47393fc0c5f2c5c98a979"), "name" : "zhangsan", "age" : "</span><span style="color: #800000; font-weight: bold;">23</span><span style="color: #000000;">", "adrss" : "zhenzhou" }
  10. { "_id" : ObjectId("5de481d56829d245aa1eb137"), "name" : "wangwu", "age" : "</span><span style="color: #800000; font-weight: bold;">12</span><span style="color: #000000;">", "adress" : "shanghai" }
  11. </span><span style="color: #808080;">></span> db.user_info.remove({name:<span style="color: #ff0000;">‘</span><span style="color: #ff0000;">zhangsan</span><span style="color: #ff0000;">‘</span><span style="color: #000000;">})
  12. WriteResult({ "nRemoved" : </span><span style="color: #800000; font-weight: bold;">1</span><span style="color: #000000;"> })
  13. </span><span style="color: #808080;">></span><span style="color: #000000;"> db.user_info.find()
  14. { "_id" : ObjectId("5de481d56829d245aa1eb137"), "name" : "wangwu", "age" : "</span><span style="color: #800000; font-weight: bold;">12</span>", "adress" : "shanghai" }

 

想删除所有数据,可以使用以下方式(类似常规 SQL 的 truncate 命令)
db.user_info.remove({})
db.user_info.find()

 

MongoDB的删除操作

标签:方式   switch   drs   truncate   zha   OLE   rop   操作   cer   

人气教程排行