MongoDb基本的crud

最新推荐文章于 2023-08-09 20:02:07 发布

账号已失效

最新推荐文章于 2023-08-09 20:02:07 发布

阅读量140

点赞数 1

CC 4.0 BY-SA版权

分类专栏：非关系型数据库文章标签： Nosql CRUD MongoDB

本文链接：https://blog.youkuaiyun.com/qq_36332554/article/details/99634611

非关系型数据库专栏收录该内容

1 篇文章

订阅专栏

本文详细介绍MongoDB中的Insert、Find、Update及Delete等核心操作，包括单条与批量文档的增删改查，以及如何使用条件筛选进行精确操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

execute entire 执行整个
execute statement cursor 执行语句光标

execute selection 执行选择

//数据源

db.inventory.insertMany([

{ item: "journal", qty: 25, size: { h: 14, w: 21, uom: "cm" }, status: "A" },

{ item: "notebook", qty: 50, size: { h: 8.5, w: 11, uom: "in" }, status: "A" },

{ item: "paper", qty: 100, size: { h: 8.5, w: 11, uom: "in" }, status: "D" },

{ item: "planner", qty: 75, size: { h: 22.85, w: 30, uom: "cm" }, status: "D" },

{ item: "postcard", qty: 45, size: { h: 10, w: 15.25, uom: "cm" }, status: "A" }

]);

//往集合中插入一条文档 collection是集合(相当于数据库中的表)
db.collection.insertOne(
{ item: "journal", qty: 25, size: { h: 14, w: 21, uom: "cm" }, status: "A" }
)
//往集合中插入多个文档
db.collection.insertMany([
{ item: "notebook", qty: 50, size: { h: 8.5, w: 11, uom: "in" }, status: "A" },

{ item: "paper", qty: 100, size: { h: 8.5, w: 11, uom: "in" }, status: "D" },

{ item: "planner", qty: 75, size: { h: 22.85, w: 30, uom: "cm" }, status: "D" }
])
//查询所有,db.collection.find()，相当于：SELECT * FROM table_name

//按条件查询db.collection.find({item:"paper"})，相当于SELECT * FROM table_name WHERE name = ?

//指定AND条件查询，相当于SELECT * FROM inventory WHERE status = “A” AND qty < 30
db.collection.find(
{
item:"notebook",
qty:{
$lt: 70
}
}
)

//指定OR条件，相当于SELECT * FROM inventory WHERE status = “A” OR qty < 30
db.collection.find(
{
$or:[
{
status:'A'
},
{
item:'paper'
}
]
}
)

//指定AND和OR条件，相当于SELECT * FROM inventory WHERE status = “A” AND （ qty < 30 OR item LIKE “p％” ）
db.collection.find(
{
status:'A',
$or:[
{qty:{
$lt: 70
}},
{
item:/^p/
}
]
}
)

//Update操作详解
//数据源
db.collection.insertMany( [
{ item: "canvas", qty: 100, size: { h: 28, w: 35.5, uom: "cm" }, status: "A" },
{ item: "journal", qty: 25, size: { h: 14, w: 21, uom: "cm" }, status: "A" },
{ item: "mat", qty: 85, size: { h: 27.9, w: 35.5, uom: "cm" }, status: "A" },
{ item: "mousepad", qty: 25, size: { h: 19, w: 22.85, uom: "cm" }, status: "P" },
{ item: "notebook", qty: 50, size: { h: 8.5, w: 11, uom: "in" }, status: "P" },
{ item: "paper", qty: 100, size: { h: 8.5, w: 11, uom: "in" }, status: "D" },
{ item: "planner", qty: 75, size: { h: 22.85, w: 30, uom: "cm" }, status: "D" },
{ item: "postcard", qty: 45, size: { h: 10, w: 15.25, uom: "cm" }, status: "A" },
{ item: "sketchbook", qty: 80, size: { h: 14, w: 21, uom: "cm" }, status: "A" },
{ item: "sketch pad", qty: 95, size: { h: 22.85, w: 30.5, uom: "cm" }, status: "A" }
] );

//更新某一条文档
db.collection.updateOne(
{
item:"notebook"
},
{
$set:{
"size.uom":'out',
status:"B"
},
$currentDate:{
lastModified:true
}
}
)

//更新多条文档 qty小于80更新 size.uom值为:sbb，status为草泥马，并添加一个时间$currentDate
db.collection.updateMany(
{
qty:{
$lt:80
}
},
{
$set:{
"size.uom":'sbb',
status:'草泥马'
},
$currentDate:{
lastTime:true
}
}
)

//替换某一条文档
db.collection.replaceOne(
{item:'mat'},
{item:'mat',qty:'85',status:'A',size:{h:'15',w:'20',uom:'obd'}}
)

//Delete操作详解
//数据源
db.collection.insertMany( [
{ item: "journal", qty: 25, size: { h: 14, w: 21, uom: "cm" }, status: "A" },
{ item: "notebook", qty: 50, size: { h: 8.5, w: 11, uom: "in" }, status: "P" },
{ item: "paper", qty: 100, size: { h: 8.5, w: 11, uom: "in" }, status: "D" },
{ item: "planner", qty: 75, size: { h: 22.85, w: 30, uom: "cm" }, status: "D" },
{ item: "postcard", qty: 45, size: { h: 10, w: 15.25, uom: "cm" }, status: "A" },
] );

//删除所有文档
db.collection.deleteMany({})
//删除与条件匹配的所有文档
db.collection.deleteMany(
{status:'A'}
)
//删除与条件匹配的一个文档
db.collection.deleteOne(
{status:'A'}
)