代码改变世界

mysql 导入csv 转义

 

TERMINATED :分隔符

ESCAPED :转义用什么标示,‘’ 不设置转义符

LOAD DATA LOCAL INFILE '/home/tmp/1999/holder.csv'  INTO TABLE 1999_holder  CHARACTER SET utf8  FIELDS TERMINATED BY ',' escaped by '';

posted on 2019-04-02 15:47  Captain林  阅读(199)  评论(0编辑  收藏  举报

导航