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 '';
life is a jounery,yes
TERMINATED :分隔符
ESCAPED :转义用什么标示,‘’ 不设置转义符
LOAD DATA LOCAL INFILE '/home/tmp/1999/holder.csv' INTO TABLE 1999_holder CHARACTER SET utf8 FIELDS TERMINATED BY ',' escaped by '';