查询:
查询所有数据
User.find().then(result => console.log(result));
//查询单个数据
User.find({_id:‘5c09f267aeb04b22f8460968’}).then(result => console.log(result));
//只打印一个
User.findOne().then(result =>console.log(result));
//选择要查询的字段
User.find().select(‘name email -_id’).then(result => console.log(result));
//匹配大于小于
User.find({age:{
g
t
:
20
,
gt:20,
gt:20,lt:40}}).then(result => console.log(result));
//匹配包含
User.find({hobbies:{$in:[‘敲代码’]}}).then(result => console.log(result));
排序
//升序排列
User.find().sort(‘age’).then(result => console.log(result));
//降序排列
User.find().sort(’-age’).then(result => console.log(result));
删除
//删除文档
User.findOneAndDelete({_id:’’}).then(result => console.log(result));
User.deleteMany({}).then(result => console.log(result));//传空值会把全部数据都删掉
更新
//更新数据库中文档
User.updateOne({查询条件},{要修改的值}).then(result => console.log(result));
User.updateMany({查询条件},{要修改的值}).then(result => console.log(result));