MongoDB怎样处理批量update违反唯一约束的key

MongoDBupdatekey MongoDBupdateupsert
kk_device_likes_game:{“device_id” : 1,
“target_type” : 1,
“target_id” : 1 }db.kk_device_likes_game.update({“target_type”:5,”target_id”:NumberLong(1030)},{“$set”:{“target_id”:NumberLong(1031)}},true,true) “target_type”:5,”target_id”:NumberLong(1030)target_idNumberLong(1030)NumberLong(1031) _idsqlupdate where target_type=5 and
target_id=1030 and _id = var cursor =
db.kk_device_likes_game.find({“target_type”:5,”target_id”:NumberLong(1030)})while
(cursor.hasNext()) {doc=cursor.next();a=db.免费云主机域名kk_device_likes_game.update({_id:doc._id,”target_type”:5,”target_id”:NumberLong(1030)},{“$set”:{“target_id”:NumberLong(1031)}})print(a)} {“device_id”
: 1,”target_type” : 1,”target_id” : 1}device_id target_type=5 and target_id=1031
device_iddevice_idsqlupdate where
target_type=5 and target_id=1030 and device_id not in (select device_id from
where target_type=5 and target_id=1031 ) var cursor =
db.kk_device_likes_game.find({“target_type”:5,”target_id”:NumberLong(1030)})while
(cursor.hasNext()) {doc=cursor.next();a=db.kk_device_likes_game.find({device_id:doc.device_id,”target_type”:5,”target_id”:NumberLong(1031)}).count()if ( a == 0 ){
db.kk_device_likes_game.update({_id:doc._id,”target_type”:5,”target_id”:NumberLong(1030)},{“$set”:{“target_id”:NumberLong(1031)}}); }else {
print(“_id” + doc._id + “” ); }} i=0var cursor =
db.kk_device_likes_game.find({“target_type”:5,”target_id”:NumberLong(1030)})while
(cursor.hasNext()) {
doc=cursor.next();a=db.kk_device_likes_game.find({device_id:doc.device_id,”target_type”:5,”target_id”:NumberLong(1031)}).count()i=i+a}431 db.kk_device_likes_game.find({“target_type”:5,”target_id”:NumberLong(1030)}).count()431 MongoDBupdatekey

相关推荐: Sqlserver的SQL语句实现分页查询

在应用程序的开发中，如果数据库中的数据量过于的庞大，则需要针对查询数据做分页处理，取出对应分页中的数据，在Sqlserver分页的语句写法中，有两种比较常用，一种是数据表中含有自增量Id的情况，可以根据Id的大小顺序进行分页，另一种是数据库中不存在Int类型的…