mysql命令行导出数据到csv文件
SELECT * FROM www_orders.fx_log_orders where ordlog_record_date>='2020-01-01' and ordlog_record_date<='2020-12-31' and ordlog_comment like '%Send%';
INTO OUTFILE '/var/lib/mysql-files/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINA
原创
2021-03-10 11:42:34 ·
1007 阅读 ·
1 评论