MongoDB操作.docx
- 文档编号:4267015
- 上传时间:2022-11-28
- 格式:DOCX
- 页数:16
- 大小:18.95KB
MongoDB操作.docx
《MongoDB操作.docx》由会员分享,可在线阅读,更多相关《MongoDB操作.docx(16页珍藏版)》请在冰豆网上搜索。
MongoDB操作
一、数据库操作
1.显示当前选择的数据库
[root@weekend05~]#mongod--dbpath/data/db/
[root@weekend05~]#mongo
MongoDBshellversion:
3.2.6
connectingto:
test
。
。
。
。
>db
test
2.创建或切换数据库MyDB
>useMyDB
switchedtodbMyDB
>db
MyDB
3.查看所有数据库
>showdbs
local0.000GB
4.向MyDB插入一个文件
5.查看所有数据库
>db.movie.insert({"name":
"tutorialsyiibai"})
WriteResult({"nInserted":
1})
>showdbs
MyDB0.000GB
local0.000GB
6.删除数据库MyDB
>db.dropDatabase()
{"dropped":
"MyDB","ok":
1}
二、集合操作
1.显式和隐式创建集合movie
显示创建
>db.createCollection("movie")
{"ok":
1}
隐式创建
>db.movie.insert({"name":
"tutorialsyiibai"})
WriteResult({"nInserted":
1})
2.查询所有集合
>showcollections
movie
>db.getCollectionNames();
["movie"]
3.查看集合总数据量
>db.movie.count();
1
4.查看movie集合所在数据库
>db.movie.getDB();
MyDB
5.查看当前集合movie状态
db.movie.stats();
{
"ns":
"MyDB.movie",
"count":
1,
"size":
49,
"avgObjSize":
49,
"storageSize":
16384,
"capped":
false,
"wiredTiger":
{
"metadata":
{
"formatVersion":
1
},
"creationString":
"allocation_size=4KB,app_metadata=(formatVersion=1),block_allocation=best,block_compressor=snappy,cache_resident=0,checksum=on,colgroups=,collator=,columns=,dictionary=0,encryption=(keyid=,name=),exclusive=0,extractor=,format=btree,huffman_key=,huffman_value=,immutable=0,internal_item_max=0,internal_key_max=0,internal_key_truncate=,internal_page_max=4KB,key_format=q,key_gap=10,leaf_item_max=0,leaf_key_max=0,leaf_page_max=32KB,leaf_value_max=64MB,log=(enabled=),lsm=(auto_throttle=,bloom=,bloom_bit_count=16,bloom_config=,bloom_hash_count=8,bloom_oldest=0,chunk_count_limit=0,chunk_max=5GB,chunk_size=10MB,merge_max=15,merge_min=0),memory_page_max=10m,os_cache_dirty_max=0,os_cache_max=0,prefix_compression=0,prefix_compression_min=4,source=,split_deepen_min_child=0,split_deepen_per_child=0,split_pct=90,type=file,value_format=u",
"type":
"file",
"uri":
"statistics:
table:
collection-2-2834400305576058642",
"LSM":
{
"bloomfilterfalsepositives":
0,
"bloomfilterhits":
0,
"bloomfiltermisses":
0,
"bloomfilterpagesevictedfromcache":
0,
"bloomfilterpagesreadintocache":
0,
"bloomfiltersintheLSMtree":
0,
"chunksintheLSMtree":
0,
"highestmergegenerationintheLSMtree":
0,
"queriesthatcouldhavebenefitedfromaBloomfilterthatdidnotexist":
0,
"sleepforLSMcheckpointthrottle":
0,
"sleepforLSMmergethrottle":
0,
"totalsizeofbloomfilters":
0
},
"block-manager":
{
"allocationsrequiringfileextension":
3,
"blocksallocated":
3,
"blocksfreed":
0,
"checkpointsize":
8192,
"fileallocationunitsize":
4096,
"filebytesavailableforreuse":
0,
"filemagicnumber":
120897,
"filemajorversionnumber":
1,
"filesizeinbytes":
16384,
"minorversionnumber":
0
},
"btree":
{
"btreecheckpointgeneration":
7,
"column-storefixed-sizeleafpages":
0,
"column-storeinternalpages":
0,
"column-storevariable-sizeRLEencodedvalues":
0,
"column-storevariable-sizedeletedvalues":
0,
"column-storevariable-sizeleafpages":
0,
"fixed-recordsize":
0,
"maximuminternalpagekeysize":
368,
"maximuminternalpagesize":
4096,
"maximumleafpagekeysize":
2867,
"maximumleafpagesize":
32768,
"maximumleafpagevaluesize":
67108864,
"maximumtreedepth":
3,
"numberofkey/valuepairs":
0,
"overflowpages":
0,
"pagesrewrittenbycompaction":
0,
"row-storeinternalpages":
0,
"row-storeleafpages":
0
},
"cache":
{
"bytesreadintocache":
0,
"byteswrittenfromcache":
143,
"checkpointblockedpageeviction":
0,
"datasourcepagesselectedforevictionunabletobeevicted":
0,
"hazardpointerblockedpageeviction":
0,
"in-memorypagepassedcriteriatobesplit":
0,
"in-memorypagesplits":
0,
"internalpagesevicted":
0,
"internalpagessplitduringeviction":
0,
"leafpagessplitduringeviction":
0,
"modifiedpagesevicted":
0,
"overflowpagesreadintocache":
0,
"overflowvaluescachedinmemory":
0,
"pagesplitduringevictiondeepenedthetree":
0,
"pagewrittenrequiringlookasiderecords":
0,
"pagesreadintocache":
0,
"pagesreadintocacherequiringlookasideentries":
0,
"pageswrittenfromcache":
2,
"pageswrittenrequiringin-memoryrestoration":
0,
"unmodifiedpagesevicted":
0
},
"compression":
{
"compressedpagesread":
0,
"compressedpageswritten":
0,
"pagewrittenfailedtocompress":
0,
"pagewrittenwastoosmalltocompress":
2,
"rawcompressioncallfailed,additionaldataavailable":
0,
"rawcompressioncallfailed,noadditionaldataavailable":
0,
"rawcompressioncallsucceeded":
0
},
"cursor":
{
"bulk-loadedcursor-insertcalls":
0,
"createcalls":
1,
"cursor-insertkeyandvaluebytesinserted":
50,
"cursor-removekeybytesremoved":
0,
"cursor-updatevaluebytesupdated":
0,
"insertcalls":
1,
"nextcalls":
0,
"prevcalls":
1,
"removecalls":
0,
"resetcalls":
2,
"restartedsearches":
0,
"searchcalls":
0,
"searchnearcalls":
0,
"truncatecalls":
0,
"updatecalls":
0
},
"reconciliation":
{
"dictionarymatches":
0,
"fast-pathpagesdeleted":
0,
"internalpagekeybytesdiscardedusingsuffixcompression":
0,
"internalpagemulti-blockwrites":
0,
"internal-pageoverflowkeys":
0,
"leafpagekeybytesdiscardedusingprefixcompression":
0,
"leafpagemulti-blockwrites":
0,
"leaf-pageoverflowkeys":
0,
"maximumblocksrequiredforapage":
0,
"overflowvalueswritten":
0,
"pagechecksummatches":
0,
"pagereconciliationcalls":
2,
"pagereconciliationcallsforeviction":
0,
"pagesdeleted":
0
},
"session":
{
"objectcompaction":
0,
"opencursorcount":
1
},
"transaction":
{
"updateconflicts":
0
}
},
"nindexes":
1,
"totalIndexSize":
16384,
"indexSizes":
{
"_id_":
16384
},
"ok":
1
}
>
6.集合movie重命名
>db.movie.renameCollection("movies");
{"ok":
1}
7.集合movie复制
>db.movies.copyTo("movie")
WARNING:
db.evalisdeprecated
1
8.删除集合movie
>db.movies.drop();
true
9.查看集合movie帮助
>db.movie.help();
DBCollectionhelp
db.movie.find().help()-showDBCursorhelp
。
。
。
下面内容太多省略
三、文档操作
1.插入操作
a.单个插入
>db.movie.insert({"name":
"HuanLeSong","Times":
10000})
WriteResult({"nInserted":
1})
>db.movie.insert({"name":
"SanJie","Times":
20000})
WriteResult({"nInserted":
1})
>db.movie.insert({"name":
"SanJie","Address":
"China"})
WriteResult({"nInserted":
1})
>db.movie.find()
{"_id":
ObjectId("5752948a6655ed3d2695cc1d"),"name":
"tutorialsyiibai"}
{"_id":
ObjectId("575295dd6655ed3d2695cc1e"),"name":
"HuanLeSong","Times":
10000}
{"_id":
ObjectId("575295ee6655ed3d2695cc1f"),"name":
"SanJie","Times":
20000}
{"_id":
ObjectId("575296006655ed3d2695cc20"),"name":
"SanJie","Address":
"China"}
创建文档变量,对象
>movieVar1={"name":
"HuanLeSong","Times":
10000};
{"name":
"HuanLeSong","Times":
10000}
>movieVar2={"name":
"SanJie","Times":
20000};
{"name":
"SanJie","Times":
20000}
>movieVar3={"name":
"SanJie","Address":
"China"};
{"name":
"SanJie","Address":
"China"}
>db.movie.insert(movieVar1)
WriteResult({"nInserted":
1})
>db.movie.insert(movieVar2)
WriteResult({"nInserted":
1})
>db.movie.insert(movieVar3)
WriteResult({"nInserted":
1})
>db.movie.find()
{"_id":
ObjectId("574e52d8cfe9d7161059ed50"),"name":
"tutorialsyiibai"}
{"_id":
ObjectId("574e550dcfe9d7161059ed51"),"name":
"HuanLeSong","Times":
10000}
{"_id":
ObjectId("574e5517cfe9d7161059ed52"),"name":
"SanJie","Times":
20000}
{"_id":
ObjectId("574e551acfe9d7161059ed53"),"name":
"SanJie","Address":
"China"}
{"_id":
ObjectId("574e55a0cfe9d7161059ed54"),"name":
"HuanLeSong","Times":
10000}
{"_id":
ObjectId("574e55a0cfe9d7161059ed55"),"name":
"SanJie","Times":
20000}
{"_id":
ObjectId("574e55a0cfe9d7161059ed56"),"name":
"SanJie","Address":
"China"}
>db.movie.insert({"_id":
08001,"name":
"zhangsan"})
WriteResult({"nInserted":
1})
>db.movie.find()
{"_id":
ObjectId("574e52d8cfe9d7161059ed50"),"name":
"tutorialsyiibai"}
{"_id":
ObjectId("574e550dcfe9d7161059ed51"),"name":
"HuanLeSong","Times":
10000}
{"_id":
ObjectId("574e5517cfe9d7161059ed52"),"name":
"SanJie","Times":
20000}
{"_id":
ObjectId("574e551acfe9d7161059ed53"),"name":
"SanJie","Address":
"China"}
{"_id":
ObjectId("574e55a0cfe9d7161059ed54"),"name":
"HuanLeSong","Times":
10000}
{"_id":
ObjectId("574e55a0cfe9d7161059ed55"),"name":
"SanJie","Times":
20000}
{"_id":
ObjectId("574e55a0cfe9d7161059ed56"),"name":
"SanJie","Address":
"China"}
{"_id":
8001,"name":
"zhangsan"}db.movie.insert({"_id":
08001,"name":
"lisi"})
db.movie.save({"_id":
08001,"name":
"lisi"})
db.movie.find()
>db.movie.insert({"_id":
08001,"name":
"lisi"})
WriteResult({
"nInserted":
0,
"writeError":
{
"code":
11000,
"errmsg":
"E11000duplicatekeyerrorcollection:
mydb.movieindex:
_id_dupkey:
{:
8001.0}"
}
})
>db.movie.save({"_id":
08001,"name":
"lisi"})
WriteResult({"nMatched":
1,"nUpserted":
0,"nModified":
1})
>db.movie.find()
{"_id":
ObjectId("574e52d8cfe9d7161059ed50"),"name":
"tutorialsyiibai"}
{"_id":
ObjectId("574e550dcfe9d7161059ed51"),"name":
"HuanLeSong","Times":
10000}
{"_id":
ObjectId("574e5517cfe9d7161059ed52"),"name":
"SanJie","Times":
20000}
{"_id":
ObjectId("574e551acfe9d7161059ed53"),"name":
"SanJie","Address":
"China"}
{"_id":
ObjectId("574e55a0cfe9d7161059ed54"),"name":
"HuanLeSong","Times":
10000}
{
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- MongoDB 操作