1. 導出不帶表頭的CSV數據
SELECT dataid, recordfilename INTO OUTFILE '/tmp/uk_callcenter_event3.csv'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
FROM table_name
WHERE createtime >= '2024-03-27 22:00:00' AND createtime <= '2024-04-29 23:59:59' AND timehour >= '22:00:00' AND timehour <= '23:59:59'
order by createtime DESC;
解釋：
FIELDS TERMINATED BY ',' # 是字段分割，即每個導出的字段值通過這個指定的符號分割
LINES TERMINATED BY '\n' # 是一行數據分割
2. 導出帶表頭的CSV數據
SELECT 'id', 'starttime', 'discalled', 'discaller', 'dataid', 'language', 'idno', 'serviceid'
UNION ALL
SELECT ID, starttime, discalled, DISCALLER, dataid, language, idno, serviceid
INTO OUTFILE '/tmp/uk_callcenter_event1.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM table_name
WHERE createtime >= '2024-03-27 22:00:00' AND createtime <= '2024-04-29 23:59:59' AND timehour >= '22:00:00' AND timehour <= '23:59:59'
ORDER BY createtime DESC;
3. Java中如何處理CSV數據
可以使用Hutool工具類中的方法處理CSV數據。
public static void main(String[] args) {CsvReader reader = CsvUtil.getReader(); // 加載 Csv 字符處理對象reader.setFieldSeparator(','); // 設置字段分割符，默認就是逗號List<TestBean> result = reader.read(ResourceUtil.getUtf8Reader("./your.csv"), TestBean.class); // 把 CSV 數據映射到 JavaBean 對象中
}@Data
private class TestBean {private String dataid;private String recordfilename;
}
更多內容歡迎訪問我的博客。
