MONGODB
三花猫棉花
这个作者很懒,什么都没留下…
展开
-
Command failed with error 28 (PathNotViable): ‘Cannot create field ‘DirectOrderAccept‘ in element
加上.$后可以了,但是没法一次刷完,也不知道咋成功的。原创 2022-07-18 22:10:02 · 424 阅读 · 0 评论 -
DTS-11005: com.mongodb.MongoCommandException: Command failed with error 13
MongoDB通过DTS导入数据时报错DTS-11005: com.mongodb.MongoCommandException: Command failed with error 13解:数据权限问题,为账号增加权限:导入成功。原创 2022-07-12 11:55:15 · 1395 阅读 · 0 评论 -
Timed out after 30000 ms while waiting for a server that matches WritableServerSelector
DataX从Mysql到MongoDB迁移数据,写入时报错:Timed out after 30000 ms while waiting for a server that matches WritableServerSelector.账号权限问题:使用账号建在admin库下,删除后在指定库重建读写账号,重启任务执行成功。...原创 2022-07-07 16:37:42 · 1965 阅读 · 0 评论 -
MONGODB关于通过排序规则设置规避大小写区分
排序规则参数{ locale: <string>, caseLevel: <boolean>, caseFirst: <string>, strength: <int>, numericOrdering: <boolean>, alternate: <string>, maxVariable: <string>, backwards: <boolean>}新原创 2022-07-07 11:09:23 · 413 阅读 · 0 评论 -
MongoDB 管道函数aggregate使用记录
MongoDB多集合关联并更新数据db.workjsoninfo8.find({}).forEach(function(item){ db.workjsoninfo.updateMany( {WorkOrderId:item.WorkOrderId }, {$set:{WorkAddressInfo:item.workaddressinfo}} )});原创 2022-06-09 15:07:00 · 547 阅读 · 0 评论 -
MONGODB增删改查基础操作
db.workingjsoninfo_pre.find({$and:[ {$or:[{ProName:'北京市'},{ProName:'西藏自治区'},{CityName:'石家庄市'},{AreaName:'槐荫区'}]}, {$or:[{WorkStatus:3},{WorkStatus:4},{WorkStatus:6},{WorkStatus:13},{WorkStatus:14},{WorkStatus:15},{WorkStatus:17},{WorkStatus:12}]}, {A原创 2022-06-08 09:17:52 · 156 阅读 · 0 评论