CSV 匯出匯入

CSV 匯入

$ mysql --local-infile -uroot -p FDC < 2.1_import.sql

2.1_import.sql

-- FDC.FDC_FILTER_POINT.csv
load data local infile '/root/FDC_Issue/FDC.FDC_FILTER_POINT.csv'
into table FDC_FILTER_POINT
fields terminated by ','
enclosed by '"'
lines terminated by '\n';

CSV 匯出

直接使用 mysql 外部指令導出結果，並格式化為 CSV

mysql -uroot -pThisispassword -e "select date(logtime) as day, count(*) as rows from syslog" syslog | tr '\t' ',' > syslog_rows.csv