mysql导入csv文件_mysql导入csv文件速度

①.、shell先修改csv文本编码格式

 iconv -f GB18030 -t utf-8 "$gb2312file" > "$utf8file"    #gb18030是2312的一个超集

LOAD DATA INFILE '/tmp/file.csv'
INTO TABLE t1
CHARACTER SET utf8
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'

(1)字段之间以逗号分隔,数据行之间以\r\n分隔；
(2)字符串以半角双引号包围,字符串本身的双引号用两个双引号表示

csv导出
select * from test_info   
into outfile '/tmp/test.csv'   
fields terminated by ',' optionally enclosed by '"' escaped by '"'   
lines terminated by '\r\n'; 

csv导入
load data infile '/tmp/test.csv'   
into table test_info    
fields terminated by ','  optionally enclosed by '"' escaped by '"'   
lines terminated by '\r\n';   

mysql快速执行脚本
mysql -h 172.21.210.24 -P 4000 -u root -D rkw_ezc_prod -ppasswd <
以上就是土嘎嘎小编为大家整理的mysql导入csv文件相关主题介绍,如果您觉得小编更新的文章只要能对粉丝们有用,就是我们最大的鼓励和动力,不要忘记讲本站分享给您身边的朋友哦！！