mongodb 建库，建表，查询，更新，删除

最新推荐文章于 2024-04-24 15:14:45 发布

weixin_34107955

最新推荐文章于 2024-04-24 15:14:45 发布

阅读量732

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/u/1791060/blog/652112

版权

2019独角兽企业重金招聘Python工程师标准>>>

####查询db > show dbs

local  0.078GB

####建库及建表 > use db1

switched to db db1

> db.table1.insert({name:'gongjun',age:25})

WriteResult({ "nInserted" : 1 })

> show dbs

db1    0.078GB
local  0.078GB

show tables

system.indexes
table1

####删表 > db.table1.drop()

true

> show tables;

system.indexes

####删库 #当前的库 > db.dropDatabase()

{ "dropped" : "db1", "ok" : 1 }

####插入数据

> db.table1.insert({name:'gongjun',age:25})

WriteResult({ "nInserted" : 1 })

> db.table1.find()

{ "_id" : ObjectId("570101edd2aad932b6e8d83f"), "name" : "gongjun", "age" : 25 }

> document={name:'world',age:55}

{ "name" : "world", "age" : 55 }

> db.table1.insert(document)

WriteResult({ "nInserted" : 1 })

> db.table1.find()

{ "_id" : ObjectId("570101edd2aad932b6e8d83f"), "name" : "gongjun", "age" : 25 }
{ "_id" : ObjectId("570102b5d2aad932b6e8d842"), "name" : "world", "age" : 55 }

####更新文档 #####update > db.table1.update({name:'gongjun',age:25},{$set:{'name':'gongjun1',age:26}},{upsert:true,multi:true}) #upsert：不存在则为insert #multi：默认false，只更新第一个文档

WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })

> db.table1.find()

{ "_id" : ObjectId("57010327d2aad932b6e8d843"), "name" : "gongjun1", "age" : 26 }
{ "_id" : ObjectId("5701039cd2aad932b6e8d844"), "name" : "world", "age" : 55 }

#####save 替换objectid：5701039cd2aad932b6e8d844的文档 > db.table1.save({ "_id" : ObjectId("5701039cd2aad932b6e8d844"), "name" : "hello,world", "age" : 56 })

WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })

> db.table1.find()

{ "_id" : ObjectId("57010327d2aad932b6e8d843"), "name" : "gongjun1", "age" : 26 }
{ "_id" : ObjectId("5701039cd2aad932b6e8d844"), "name" : "hello,world", "age" : 56 }

####删除数据 > db.table1.remove({name:'hello,world'},{justone:true}) #justone:最多删除一条，默认false

WriteResult({ "nRemoved" : 1 })

> db.table1.find()

{ "_id" : ObjectId("57010327d2aad932b6e8d843"), "name" : "gongjun1", "age" : 26 }

####查询 > db.table1.find()

{ "_id" : ObjectId("57010327d2aad932b6e8d843"), "name" : "gongjun1", "age" : 26 }
{ "_id" : ObjectId("57010785d2aad932b6e8d845"), "name" : "hello", "age" : 123 }
{ "_id" : ObjectId("5701078cd2aad932b6e8d846"), "name" : "world", "age" : 12 }
{ "_id" : ObjectId("57010796d2aad932b6e8d847"), "name" : "jia", "age" : 45 }
{ "_id" : ObjectId("5701079fd2aad932b6e8d848"), "name" : "yi", "age" : 32 }
{ "_id" : ObjectId("570107d4d2aad932b6e8d849"), "name" : "jia", "age" : 45 }

> db.table1.find({age:45})

{ "_id" : ObjectId("57010796d2aad932b6e8d847"), "name" : "jia", "age" : 45 }
{ "_id" : ObjectId("570107d4d2aad932b6e8d849"), "name" : "jia", "age" : 45 }

> db.table1.find({age:45}).limit(1) #查询一条

{ "_id" : ObjectId("57010796d2aad932b6e8d847"), "name" : "jia", "age" : 45 }

> db.table1.find({$or:[{age:45},{name:'gongjun1'}]}) #or条件查询age为45或name为gongjun1

{ "_id" : ObjectId("57010327d2aad932b6e8d843"), "name" : "gongjun1", "age" : 26 }
{ "_id" : ObjectId("57010796d2aad932b6e8d847"), "name" : "jia", "age" : 45 }
{ "_id" : ObjectId("570107d4d2aad932b6e8d849"), "name" : "jia", "age" : 45 }

> db.table1.find({$or:[{name:'jia'},{name:'bin'},{name:'gongjun1'}],age:{$gt:10}}) #查询name在jia，bin,gongjun1并且age>10的文档

{ "_id" : ObjectId("57010327d2aad932b6e8d843"), "name" : "gongjun1", "age" : 26 }
{ "_id" : ObjectId("57010796d2aad932b6e8d847"), "name" : "jia", "age" : 45 }
{ "_id" : ObjectId("570107d4d2aad932b6e8d849"), "name" : "jia", "age" : 45 }

####排序 > db.table1.find().sort({name:1,age:-1}) #1:生序排列,-1:降序排列

{ "_id" : ObjectId("57010327d2aad932b6e8d843"), "name" : "gongjun1", "age" : 26 }
{ "_id" : ObjectId("57010785d2aad932b6e8d845"), "name" : "hello", "age" : 123 }
{ "_id" : ObjectId("57010b3ed2aad932b6e8d84a"), "name" : "jia", "age" : "65" }
{ "_id" : ObjectId("57010796d2aad932b6e8d847"), "name" : "jia", "age" : 45 }
{ "_id" : ObjectId("570107d4d2aad932b6e8d849"), "name" : "jia", "age" : 45 }
{ "_id" : ObjectId("5701078cd2aad932b6e8d846"), "name" : "world", "age" : 12 }
{ "_id" : ObjectId("5701079fd2aad932b6e8d848"), "name" : "yi", "age" : 32 }

转载于:https://my.oschina.net/u/1791060/blog/652112