mysql 查看 分组

1. top
   
2. ctrl+c
   
3. 
   
4. myslq -u xxx -p
   
5. show full processlist;
   
6. exit;

复制代码

分组查询

1. SELECT `status`,count(*) as counts FROM %t WHERE 1 %i GROUP BY `status`

复制代码