mongodb的常见操作增删改查

插入选定数据到指定表

db.查询表名.find({"orgId" : "d63f892d-d429-4009-8c51-3a41ec0cd9fc"}).forEach(function(doc) {
  db.指定表.insert(doc);
});

更新字段值

db.orgsitecopy.update(
	{"orgId" : "d63f892d-d429-4009-8c51-3a41ec0cd9fc"},
	{$set:{"groupId":'',"examinationId":'',"company":'',"contact":'',"telNo":'',"updateStatus":''}},
	false,
	true
)

更新字段名称

db.orgsitecopy.update(
	{"orgId" : "d63f892d-d429-4009-8c51-3a41ec0cd9fc"},
	{$rename:{"supervisorSiteId":'siteId',"municipality":'city',"weChatId":'wechatId'}},
	false,
	true
)

删除字段

db.orgsitecopy.update(
	{"orgId" : "d63f892d-d429-4009-8c51-3a41ec0cd9fc"},
	{$unset:{"groupId":'',"examinationId":'',"company":'',"contact":'',"telNo":'',"updateStatus":''}},
	false,
	true
)

查询语句

查询带$ne:
db.getCollection('site').find(
	{
		"isAutoPush" : true, 
		userId:{$ne:NumberLong(1496217216341)}
	}
)

模糊查询：
db.getCollection('account').find({userName:/ecloud_/})

时间区间查询：
db.getCollection('event').find({"time" : {'$lt':1544889600000}})