mongodb-基本操作

mongodb基本操作

1.基本操作

show dbs 查看当前实例下的数据库列表

show users 显示目录

use <db_name> 切换当前数据库

db.help() 显示数据库操作命令

show collections 显示当前数据库中的集合

db.mycoll.help() 显示集合操作命令,mycoll是当前数据库下叫做mycoll的集合

db.foo.find() 对当前数据库中foo集合进行数据查找
 

2.增删改查

#插入数据
db.test.insert ( { "name" : "zhangya" , "age" :27, "ad" :"北京市朝阳区"})
db.test.insert ( [ "name" : "zhangya" , "age":27, "ad" : "北京市朝阳区"})
db.test.insert ( [ "name " : "yazhang" , "age":28, "ad" :"北京市朝阳区"})
db.test.insert ( { "name" : "xiaozhang" , "age":28, "ad" :"北京市朝阳区"})
db.test.insert ( { "name" : "xiaozhang" , "age":28, "ad": "北京市朝阳区", "sex" : "boy"))

#批量插入多条数据
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","gty":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.test.find()
db.test.find0ne()
db.inventory.find()
db.inventory.findOne()

#条件查询
db.inventory.find( { "status": "D"})
db.inventory.find( {"size.uom" : "cm"})

更新语句
db . inventory. updateone (
{"item" : "paper" },
{
   $set: {"size.uom" : "cm","status" : "P"},
   $currentDate: {"lastModified" : true }
}
)

更新多条
db.inventory. updateMany (
   {"qty" : { $lt: 50 }},
   $set: {"size.uom" : "cm", "status": "P”},
   $currentDate : { "lastModified" : true }
)

db.inventory.updateone (
  {"qty":{ $lt:50} },
  $set: {"size.uom" : "cm", "status": "P" ,
  $currentDate : {"lastModified" : true }
) 

删除内容
db.inventory .find ( {"status” : "D"})
db. inventory.deleteOne (
{ "status" : "D"})
db. inventory.find( i "status” : "P"})
db.inventory.deleteMany (
{ "status” : "P"}
)

mongdb基础​​​​​​​

NoSQL是什么

MongoDB教程-嗨客网