设为首页 加入收藏

TOP

MongoDB数据库(二):增删查改(五)
2019-09-17 18:52:31 】 浏览:209
Tags:MongoDB 数据库 增删 查改
14c9ce97c5b78a0dc"), "name" : "xiaoqiang", "age" : 20 } { "_id" : ObjectId("5c939dd44c9ce97c5b78a0dd"), "name" : "xiaoqiang", "age" : 30 } { "_id" : ObjectId("5c939dd74c9ce97c5b78a0de"), "name" : "xiaoqiang", "age" : 40 } > db.test_table01.remove({name:"xiaoqiang"},{justOne:true}) # 删除一条name等于xiaoqiang的数据 WriteResult({ "nRemoved" : 1 }) > db.test_table01.find() { "_id" : ObjectId("5c939adc4c9ce97c5b78a0db"), "name" : "xiaozhao", "age" : 20 } { "_id" : ObjectId("5c939dd14c9ce97c5b78a0dc"), "name" : "xiaoqiang", "age" : 20 } { "_id" : ObjectId("5c939dd44c9ce97c5b78a0dd"), "name" : "xiaoqiang", "age" : 30 } { "_id" : ObjectId("5c939dd74c9ce97c5b78a0de"), "name" : "xiaoqiang", "age" : 40 } > db.test_table01.remove({name:"xiaoqiang"}) # 删除所有name等于xiaoqiang的数据,共删除了3条数据 WriteResult({ "nRemoved" : 3 }) > db.test_table01.find() { "_id" : ObjectId("5c939adc4c9ce97c5b78a0db"), "name" : "xiaozhao", "age" : 20 }

6.?较运算符查询

MongoDB数据库中的?较运算符有:

=                   等于,默认是等于判断,没有运算符
$lt                 ?于
$lte                ?于等于
$gt                 ?于
$gte                ?于等于
$ne                 不等于

例子:

> db.test_table01.insert({name:"乔峰",hometown:"丐帮",gender:"male",age:32})            # 向数据表中插入四条数据
WriteResult({ "nInserted" : 1 })
> db.test_table01.insert({name:"段誉",hometown:"云南大理",gender:"male",age:22})
WriteResult({ "nInserted" : 1 })
> db.test_table01.insert({name:"虚竹",hometown:"少林寺",gender:"male",age:28})
WriteResult({ "nInserted" : 1 })
> db.test_table01.insert({name:"王语嫣",hometown:"燕子坞",gender:"female",age:18})
WriteResult({ "nInserted" : 1 })

> db.test_table01.find()
{ "_id" : ObjectId("5c939adc4c9ce97c5b78a0db"), "name" : "xiaozhao", "age" : 20 }
{ "_id" : ObjectId("5c93a1d64c9ce97c5b78a0e3"), "name" : "乔峰", "hometown" : "丐帮", "gender" : "male", "age" : 32 }
{ "_id" : ObjectId("5c93a1e74c9ce97c5b78a0e4"), "name" : "段誉", "hometown" : "云南大理", "gender" : "male", "age" : 22 }
{ "_id" : ObjectId("5c93a1f14c9ce97c5b78a0e5"), "name" : "虚竹", "hometown" : "少林寺", "gender" : "male", "age" : 28 }
{ "_id" : ObjectId("5c93a1fd4c9ce97c5b78a0e6"), "name" : "王语嫣", "hometown" : "燕子坞", "gender" : "female", "age" : 18 }

> db.test_table01.find({age:{$lt:20}})                  # 查找年龄小于20岁的所有数据
{ "_id" : ObjectId("5c93a1fd4c9ce97c5b78a0e6"), "name" : "王语
首页 上一页 2 3 4 5 6 7 8 下一页 尾页 5/10/10
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇oracle 子查询 where having from.. 下一篇MIT-6.824 Lab 3: Fault-tolerant..

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目