firemail

标题: mysql导出excel [打印本页]

作者: java 时间: 2017-11-23 11:28
标题: mysql导出excel
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

欢迎光临 firemail (http://www.firemail.wang:8088/)