概念
database schema model entity methods static virtual
- 启动mongodb
mac下面cd /usr/local/Cellar/mongodb/3.6.1/bin
sudo mongod
打开新的窗口mongo
mongodb基础操作
1. use dbs 使用数据库
2. show collections 显示集合
插入文档
db.collection_name.insert(document) 插入文档
更新文档
db.students.update({name:'yyc'},{$set:{age:300}},{multi:true}); 更新文档
-----------
$set：直接指定更新后的值db.students.update({name:'yyc'},{$set:{age:300}},{multi:true});
$inc：在原基础上累加db.students.update({name:'yyc'},{$inc:{age:1}},{multi:true});
$unset：删除指定的键db.user.update({name: 'lyx'}, {$unset: {age: ''}})
multi
$push 更新数组db.user.update({name: 'lyx'},{$push:{hobby: 'movie'}})
$ne
$addToSet 不会重复添加 db.user.update({name: 'lyx'}, {$addToSet: {hobby: 'eat'}})
$each 更新数组db.user.update({name: 'lyx'},{$push:{hobby: {$each: ['food', 'book']}}})
$pop
-----------
查找文档
db.user.find()
db.students.find({},{age:1});
db.collection_name.findOne()
$in db.student.find({age:{$in:[30,100]}},{name:1,age:1});
$nin db.student.find({age:{$nin:[30,100]}},{name:1,age:1});
$not db.student.find({age:{$not:{$gte:20,$lte:30}}});
$or db.students.find({$or:[{age:30},{age:50}]})
分页查找
db.collectoin_name.find().skip(skipNum).limit(limitNum)
索引
db.students.ensureIndex({name:1},{name:'namedIndex'}); 1代表升序
db.students.getIndexes()//查看索引
