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下导出数据

转载于:https://www.cnblogs.com/shenliang123/p/3482472.html