multi update only works with $ operators

最新推荐文章于 2022-09-01 17:29:07 发布

JesJiang

最新推荐文章于 2022-09-01 17:29:07 发布

阅读量1k

点赞数

分类专栏： mongodb shell

本文链接：https://blog.csdn.net/jiangshuanshuan/article/details/101686152

版权

mongodb 同时被 2 个专栏收录

15 篇文章 1 订阅

订阅专栏

shell

6 篇文章 0 订阅

订阅专栏

数据库执行没问题，test.sh中执行报错

WriteResult({
	"nMatched" : 0,
	"nUpserted" : 0,
	"nModified" : 0,
	"writeError" : {
		"code" : 9,
		"errmsg" : "multi update only works with $ operators"
	}
})

语句

db.user.update({"failsCount" : {"$gte":1}},{"$set":{"failsCount": 0,"active":true}},false,true)
db.user.update({"failsCount" : {"$gte":1}},{"$set":{"failsCount": 0,"active":true}},{multi:true})

需改为

db.user.update({"failsCount" : {"\$gte":10}},{"\$set":{"failsCount": 0,"active":true}},false,true)

完整如下

#!/bin/sh
echo "[`date '+%Y-%m-%d %H:%M:%S'`]start............................................."  >> /home/log/unlock.log
mongo 127.0.0.1:27017<<EOF 
use data;
db.auth("xxx","xxx");
db.user.update({"failsCount" : {"\$gte":10}},{"\$set":{"failsCount": 0,"active":true}},false,true)
exit;
echo "[`date '+%Y%m%d%H%M%S'`] end............................................."  >> /home/log/unlock.log