查询文档
查询所有
Model.find().then(res=>{
console.log(res)
})
条件查询
Model.find(条件)
Model.findOne(条件)
Model.find({name:'6'}).then(res => {
console.log(res)
})
Model.findOne({name:'2'}).then(res => {
console.log(res)
})
})
区间查询
{key:{$gt:value,$lt:value}}
Model.find({age:{$gte:18,$lte:38}}).then(res => {
console.log(res)
})
模糊查询
Model.find({city:/上/}).then(res => {
console.log(res)
})
选择要查询的字段
Modal.find().select(arg)
Model.find().select('-name').then(res => {
console.log(res)
})
查询后排序
Modal.find().sort(arg)
Model.find().sort('-age').then(res => {
console.log(res)
})
跳过多少条数据、限制查询数量(多用于分页)
Modal.find().skip(num).limit(num)
Model.find().skip(2).limit(3).then(res => {
console.log(res)
})
更新文档
更新单个文档
Modal.findOneAndUpdate(条件,更新的值)
Modal.updateOne(条件,更新的值)
mongoose.set('useFindAndModify',false)
Model.findOneAndUpdate({name:'2'},{city:'深圳'}).then(res => {
console.log(res)
})
Model.updateOne({name:'2'},{city:'上海'}).then(res => {
console.log(res)
})
更新多个文档
Modal.updateMany(条件,更新的值)
Model.updateMany({name:'2'},{city:"深圳"}).then(res => {
console.log(res)
})
删除文档
删除单个文档
Modal.findOneAndDelete(条件)
Modal.delectOne(条件)
Model.findOneAndDelete({name:'xx'}).then(res => {
console.log(res)
})
Model.deleteOne({name:'2'}).then(res => {
console.log(res)
})
删除多个文档
Modal.deleteMany(条件)
Model.deleteMany().then(res => {
console.log(res)
})