于飞的博客

select convert(t2.name using gb2312), count(*) cnt from tbl_task_info t1 left JOIN tbl_type t2 on t1.type=t2.id where t1.owner in(312039) group by t1.type order by cnt desc// 按类型统计select tmp1.

http://jingyan.baidu.com/article/ff42efa93580c4c19e2202b6.html

1. apt-get install mariadb-server2. 配置文件添加内容： vi /etc/mysql/my.cnf[client]default-character-set=utf8[mysql]default-character-set=utf8[mysqld]datadir = /mnt/data/mysqlcharacter-s...