mysql导出excel

java

mysql -h192.168.89.78 -P14040 -uadmin -p3334 wpsmail_vas --default-character-set=utf8 -e "select CONCAT('''', order_id) as order_id, FROM_UNIXTIME(modify_time/1000) as modify_time,FROM_UNIXTIME(modify_time/1000,'%Y-%c-%d %h:%i:%s') as timedd　 from v_order order by modify_time desc limit 0,10" > order.xlsx