MongoDB操作文档格式.docx
- 文档编号:17183367
- 上传时间:2022-11-28
- 格式:DOCX
- 页数:16
- 大小:18.95KB
MongoDB操作文档格式.docx
《MongoDB操作文档格式.docx》由会员分享,可在线阅读,更多相关《MongoDB操作文档格式.docx(16页珍藏版)》请在冰豆网上搜索。
:
1})
MyDB0.000GB
6.删除数据库MyDB
db.dropDatabase()
{"
dropped"
"
MyDB"
"
ok"
1}
二、集合操作
1.显式和隐式创建集合movie
显示创建
db.createCollection("
movie"
)
隐式创建
2.查询所有集合
showcollections
movie
db.getCollectionNames();
["
]
3.查看集合总数据量
db.movie.count();
1
4.查看movie集合所在数据库
db.movie.getDB();
5.查看当前集合movie状态
db.movie.stats();
{
ns"
MyDB.movie"
count"
1,
size"
49,
avgObjSize"
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"
bloomfiltermisses"
bloomfilterpagesevictedfromcache"
bloomfilterpagesreadintocache"
bloomfiltersintheLSMtree"
chunksintheLSMtree"
highestmergegenerationintheLSMtree"
queriesthatcouldhavebenefitedfromaBloomfilterthatdidnotexist"
sleepforLSMcheckpointthrottle"
sleepforLSMmergethrottle"
totalsizeofbloomfilters"
0
block-manager"
allocationsrequiringfileextension"
3,
blocksallocated"
blocksfreed"
checkpointsize"
8192,
fileallocationunitsize"
4096,
filebytesavailableforreuse"
filemagicnumber"
120897,
filemajorversionnumber"
filesizeinbytes"
minorversionnumber"
btree"
btreecheckpointgeneration"
7,
column-storefixed-sizeleafpages"
column-storeinternalpages"
column-storevariable-sizeRLEencodedvalues"
column-storevariable-sizedeletedvalues"
column-storevariable-sizeleafpages"
fixed-recordsize"
maximuminternalpagekeysize"
368,
maximuminternalpagesize"
maximumleafpagekeysize"
2867,
maximumleafpagesize"
32768,
maximumleafpagevaluesize"
67108864,
maximumtreedepth"
numberofkey/valuepairs"
overflowpages"
pagesrewrittenbycompaction"
row-storeinternalpages"
row-storeleafpages"
cache"
bytesreadintocache"
byteswrittenfromcache"
143,
checkpointblockedpageeviction"
datasourcepagesselectedforevictionunabletobeevicted"
hazardpointerblockedpageeviction"
in-memorypagepassedcriteriatobesplit"
in-memorypagesplits"
internalpagesevicted"
internalpagessplitduringeviction"
leafpagessplitduringeviction"
modifiedpagesevicted"
overflowpagesreadintocache"
overflowvaluescachedinmemory"
pagesplitduringevictiondeepenedthetree"
pagewrittenrequiringlookasiderecords"
pagesreadintocache"
pagesreadintocacherequiringlookasideentries"
pageswrittenfromcache"
2,
pageswrittenrequiringin-memoryrestoration"
unmodifiedpagesevicted"
compression"
compressedpagesread"
compressedpageswritten"
pagewrittenfailedtocompress"
pagewrittenwastoosmalltocompress"
rawcompressioncallfailed,additionaldataavailable"
rawcompressioncallfailed,noadditionaldataavailable"
rawcompressioncallsucceeded"
cursor"
bulk-loadedcursor-insertcalls"
createcalls"
cursor-insertkeyandvaluebytesinserted"
50,
cursor-removekeybytesremoved"
cursor-updatevaluebytesupdated"
insertcalls"
nextcalls"
prevcalls"
removecalls"
resetcalls"
restartedsearches"
searchcalls"
searchnearcalls"
truncatecalls"
updatecalls"
reconciliation"
dictionarymatches"
fast-pathpagesdeleted"
internalpagekeybytesdiscardedusingsuffixcompression"
internalpagemulti-blockwrites"
internal-pageoverflowkeys"
leafpagekeybytesdiscardedusingprefixcompression"
leafpagemulti-blockwrites"
leaf-pageoverflowkeys"
maximumblocksrequiredforapage"
overflowvalueswritten"
pagechecksummatches"
pagereconciliationcalls"
pagereconciliationcallsforeviction"
pagesdeleted"
session"
objectcompaction"
opencursorcount"
transaction"
updateconflicts"
}
},
nindexes"
totalIndexSize"
indexSizes"
_id_"
16384
}
6.集合movie重命名
db.movie.renameCollection("
movies"
);
7.集合movie复制
db.movies.copyTo("
WARNING:
db.evalisdeprecated
8.删除集合movie
db.movies.drop();
true
9.查看集合movie帮助
db.movie.help();
DBCollectionhelp
db.movie.find().help()-showDBCursorhelp
下面内容太多省略
三、文档操作
1.插入操作
a.单个插入
HuanLeSong"
"
Times"
10000})
SanJie"
20000})
Address"
China"
})
db.movie.find()
_id"
ObjectId("
5752948a6655ed3d2695cc1d"
),"
}
575295dd6655ed3d2695cc1e"
10000}
575295ee6655ed3d2695cc1f"
20000}
575296006655ed3d2695cc20"
创建文档变量,对象
movieVar1={"
10000};
movieVar2={"
20000};
movieVar3={"
};
db.movie.insert(movieVar1)
db.movie.insert(movieVar2)
db.movie.insert(movieVar3)
574e52d8cfe9d7161059ed50"
574e550dcfe9d7161059ed51"
574e5517cfe9d7161059ed52"
574e551acfe9d7161059ed53"
574e55a0cfe9d7161059ed54"
574e55a0cfe9d7161059ed55"
574e55a0cfe9d7161059ed56"
08001,"
zhangsan"
8001,"
}db.movie.insert({"
lisi"
db.movie.save({"
db.movie.find()
WriteResult({
writeError"
code"
11000,
errmsg"
E11000duplicatekeyerrorcollection:
mydb.movieindex:
_id_dupkey:
{:
8001.0}"
db.movie.save({"
nMatched"
1,"
nUpserted"
0,"
nModified"
{
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- MongoDB 操作