mongo 笔记 ---持续更新

mongo (强制区分文本与数字类型)  (不存在的字段不会匹配)

show dbs

切换到数据库
use db_name 


show tables

获得行数
db.tb_user.count()



$lt     <   
$lte    <= 
$gt     >    
$gte    >=   

创建索引
db.col.createIndex({"title":1})
db.col.createIndex({"title":-1})
db.col.getIndexes()


普通查询  
db.tb_filter_imei_ips.find({"end_time":{"$lte":99999999999}})

php调用
$options = array();
$options['projection'] = ['ctime'=>1];指定显示
$options['sort'] = ['ctime'=>-1];
$options['limit'] = $size;
$options['skip'] = ($page - 1) * $size;
$result = $this->_db->find($where, $options);


聚合查询 
aggregate([{
    "$match": {
        "imei": {
            "$in": [1, 2]
        }
    }
},
{
    "$group": {
        "_id": "$device_id",
        "count": {
            "$sum": 1
        },
        "imei": {
            "$first": "$imei"
        },
        "device_id": {
            "$first": "$device_id"
        },
        "doc": {
            "$first": "$$ROOT"
        }
    }
}])