select Phone,AuthCode,CreateTime from tb_phone_auth where CreateTime between ‘2014-11-01 00:00:00‘ and ‘2014-11-30 23:59:59‘  into outfile ‘/tmp/tb_phone_auth.csv‘ fields terminated by ‘,‘optionally enclosed by ‘‘ lines terminated by ‘\n‘;

MySql数据库导出csv