mysql 多字段分组统计

实现：通过"group by"关键字

语法：group by 字段

示例：select deploy_env_name,count(deploy_env_id) '云服务商数' from system_area_global where delete_status='NORMAL' group by deploy_env_id,deploy_env_name;

解释：根据deploy_env_id,deploy_env_name字段进行分组，然后使用count函数统计deploy_env_id数量