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

posted on 2013-12-19 16:39  发表是最好的记忆  阅读(366)  评论(0编辑  收藏  举报