login mysql constol:
mysql -u 用户名 -p
user 数据库名
导入到excel中
select phoneNumber,count(phoneNumber) into outfile '/local/akazam/backup/xls03.xls' from log_request_201303
where ip !='127.0.0.1'
and ts >=1362067201000
group by phoneNumber HAVING count(phoneNumber)>1;
中文编码
select convert(b using gb2312),convert(c using gb2312) into outfile 'c:\xlstt12.xls' from tt;