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"
}
}
}])