MiThink 记事本

统计查询：

SELECT SUM(IF(color='blue',1,0)) AS blue,SUM(IF(color='red',1,0)) AS red FROM items;
SELECT COUNT(color='blue' OR NULL) AS blue,COUNT(color='red' OR NULL) AS red FROM items;

导入SQL文件：

use database_name; 
set names utf8;   #或其他需要的编码
source example.sql;    #sql文件存放路径

按某列的值的出现次数降序排列：

select a,count(1) cnt from table group by a order by cnt desc