mysql匯入匯出.csv格式資料

window下匯入資料：

LOAD DATA INFILE "C:\\1.csv"

REPLACE INTO TABLE demo

CHARACTER SET gb2312

FIELDS TERMINATED BY "," ENCLOSED BY ""

LINES TERMINATED BY "\r\n";

window下匯出資料