//查询重复
db.getCollection('game_user').aggregate([
{ $group: { _id : '$userid', count: { $sum : 1 } } },
{ $match: { count: { $gt : 1} } }
])
//查询特定类型字段
db.game_user.find({score:{$type:"number"}}).count()
db.game_user.find({score:{$type:"double"}}).count()
db.game_user.find({score:{$type:"long"}}).count()
db.game_user.find({score:{$type:"int"}}).count()
MongoDB查询重复的字段
最新推荐文章于 2023-07-24 17:01:52 发布