Mongodb使用补充

mongodb://admin:123456@localhost/

db.cy.insert({title: ‘MongoDB 教程’,
description: ‘MongoDB 是一个 Nosql 数据库’,
by: ‘w3cschool’,
url: ‘http://www.w3cschool.cn‘,
tags: [‘mongodb’, ‘database’, ‘NoSQL’],
likes: 100
})

db.w3cschool.insert({"time":"202101131726"})

db.w3cschool.insert([{"a":"202101131726","b":{
"a1":"a1",
"b1":"b1"
}},{"a2":"202101131726","b2":{
"a12":"a12",
"b12":"b12"
}}])

db.w3cschool.insertMany([{"a":"202101131726","b":{
"a1":"a1",
"b1":"b1"
}},{"a2":"202101131726","b2":{
"a12":"a12",
"b12":"b12"
}}])

db.w3cschool.insertOne({"time":"202101131726"})

db.w3cschool.update({‘time’:’202101131726′},{$set:{‘time’:’你好呀’,’name’:’summer’}},false,true)

db.w3cschool.remove({"time":"你好呀"},true)

db.w3cschool.remove({"title":"你好呀"},true)

db.w3cschool.insert({"time":"202101131726"});
db.w3cschool.insert({"time":202101131726});

db.w3cschool.insert({"time":"202101131726",’name’:"summer"});
db.w3cschool.insert({"time":202101131726,’name’:’summer’});

db.w3cschool.find({‘name’:’summer’,"time":{$type : 2}});

db.w3cschool.find({‘name’:’summer’}).sort({"name":1});

查看索引

db.w3cschool.createIndex({
‘time’:1
},{background:false,unique:false
});

db.w3cschool.dropIndex("time_1")

db.w3cschool.totalIndexSize()

db.w3cschool.dropIndexes();

db.w3cschool.aggregate([{
$project:{
name:1,
time:0
}
}])

db.w3cschool.aggregate( [ { $project : { _id: 0, name : 1 , time : 1,abc:’$time’ } } ] )

mongodump -h localhost -d test -o dbdirectory E:\Program Files\MongoDB\Server\backup

mongodump -h dbhost -d dbname -o dbdirectory

mongoimport –-host localhost -d test -c w3cschool –type=json E:/test-backup.json

mongoimport –host 192.168.4.51 –port 27051 -d gamedb -c col –type=json /mbak/c2.json

mongodump -d test -o E:/test-backup.json

mongoexport -d test -o E:/test-backup.json