摘要: 从CSV文件导入到MySQL:LOAD DATA INFILE 'E:/file.csv'INTO TABLE t1CHARACTER SET gb2312FIELDS TERMINATED BY ',' ENCLOSED BY '"'LINES TERMINATED BY '\r\n'(column1, @var1)SET column2 = @var1/100;从MySQL导出到CSV文件:SELECT col1,col2,col3 FROM t1INTO OUTFILE 'E:/file.csv' 阅读全文
posted @ 2013-03-12 01:32 秦楼东 阅读(313) 评论(0) 推荐(0) 编辑