当前位置: 代码迷 >> 数据库 >> mongo札记
  详细解决方案

mongo札记

热度:8262   发布时间:2013-02-26 00:00:00.0
mongo笔记
db.users.find({$where:function(){return this.age > 30 && this.age < 35;}})db.users.find({$or:[{name:"mrj6"}, {name:"mrj9"}]})// 查询db.users.find({age:{$lt:30}})db.users.find({$or:[{$where:function(){return this.age > 30 && this.age < 35;}}, {name:"mrj6"}]})db.users.find({$or:[{$where:function(){return this.age > 30 && this.age < 35;}}, {name:"mrj6"}]}).sort({age:1})		// 1升序,-1降序db.users.save({ "_id" : ObjectId("5020a0a2f23c9896b393e7dd"), "name" : "mrj0", "age" : 20 })	// updates if exists; inserts if newdb.users.update({name:"mrj0"}, {$inc:{age:69}})$inc:increments,增加(for numbers only)$set:sets field to value.$unset:Deletes a given field.$push/$pushAll:push array$addToSet:Adds value to the array$pop:removes the last element in an array$pull:removes all occurrences of value from field$pullAll:removes all occurrences of each value in value_array from field$rename:	索引db.users.ensureIndex({name:1}, {unique:true})	// 唯一索引db.dropDatabase()	// 删除数据库db.users.drop()		// 删除表用户/安全db.addUser("user1", "123456")	// 添加用户,可以指定向哪个库添加用户,可以指定用户是否只读,第三个参数为true表示只读db.system.users.remove({user:"user1"})	// 删除用户如果要启用权限管理,需要在启动时:mongod --authdb.user.remove()		// 删除记录db.user.save({name:"mrj", pass:"123456",alias:[{type:"mail",name:"mrjeye"},{type:"qq", name:"8423525"}]})	// 添加记录db.user.find().forEach(printjson)		// 查询并打印db.user.find({},{mail:0}).forEach(printjson)	// 查询指定列db.user.update({name:"mrj"},{$push:{alias:{type:"mobile",name:"13111111111"}}})	// 更新添加指定列数据db.user.find({alias:{$exists:true}},{'alias.type':true,'alias.name':true}).limit(2).forEach(	function(collections){		var collection = collections.alias;		for(var idx in collection){			var alias = collection[idx];			print('The type is:' + alias.type + ', value is:' + alias.name + '\n');		}	});db.user.find({alias:{$exists:true}},{'alias.type':true,'alias.name':true}).forEach(function(alias){foreach(var alia in alias){print('type(' + alias[0] + '),value(' + alias.name + ')\n');})})db.user.find({alias:{$exists:true}},{'alias.type':true,'alias.name':true}).forEach(	function(alias){		alias.forEach(			function(alia){				print('type(' + alias[0] + '),value(' + alias.name + ')\n');			}		)	})

?

?

?

备份:

?

mongodump -h host:port -ddbname -o path -u user -p pass

?

?

还原:

mongorestore -h host:port -d dbname --directoryperdb dbdirectory -u user -p pass --drop

?

?

?

?

?

  相关解决方案