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';
posted @ 2015-04-22 16:42  梁小粽  阅读(243)  评论(0编辑  收藏  举报