当前位置: 代码迷 >> 综合 >> MongoDB的基本增删改查操作
  详细解决方案

MongoDB的基本增删改查操作

热度:29   发布时间:2023-10-23 17:54:50.0
mongoDB中文文档

# 可视化工具 robomongo

具体操作:

# 插入十五条不同的数据
use students
db.students.insertMany([{name:"bob",age:16,sex:"male",grade:95},{name:"bob1",age:12,sex:"female",grade:50},{name:"bob2",age:13,sex:"female",grade:80},{name:"bob3",age:14,sex:"male",grade:71},{name:"bob4",age:15,sex:"male",grade:60},{name:"tom",age:15,sex:"female",grade:36},{name:"tom1",age:16,sex:"male",grade:90},{name:"tom2",age:18,sex:"male",grade:100},{name:"tom3",age:20,sex:"female",grade:70},{name:"tom4",age:21,sex:"male",grade:88},{name:"jack",age:13,sex:"male",grade:87},{name:"jack1",age:14,sex:"female",grade:89},{name:"jack2",age:17,sex:"male",grade:98},{name:"jack3",age:19,sex:"male",grade:38},{name:"jack4",age:29,sex:"female",grade:69}])

# 查询所有的男生数据(只需要学生的姓名和年龄)

b.students.find({sex:'male'},{name:1,age:true,_id:0})   # true==1 / flase==0 要小写

# 查询成绩及格的学生信息(成绩大于等于60分)

db.students.find({grade:{'$gte':60}}

# 查询所有18随的男生和15岁的女生的数据

db.students.find({'$or':[{sex:'male',age:18},{sex:'female',age:15}]})

# 按照年龄排序

 db.students.find().sort({age:-1})   # -1为降序,1为升序

# 给这个集合(表)添加一列数据

db.students.update({},{'$set':{addr:'ShangHai'}},{multi:true})

# 给所有女学生的年龄增加一岁

db.students.update({sex:'female'},{'$inc':{age:1}},{multi:true})
  相关解决方案