mysql导出数据到excel表中
mysql> select b.username,a.subject,a.money,FROM_UNIXTIME(a.ctime) from shop_pay a INNER JOIN common_member b on a.uid=b.uid where a.ctime>='1429428970' and a.ctime<='1429689355' and a.`status` = 2 into outfile '/tmp/test.xls';