源码
load data
infile *
append into table AA
fields terminated by ','
Optionally enclosed by '"'
(A , B)
begindata
"k","\""我\"""
注解:如果是以逗号隔开的,那么其中有逗号就需要将整个字段用双引号引起来,有双引号的话就用双重双引号引起来。
结果
源码
load data
infile *
append into table AA
fields terminated by ','
Optionally enclosed by '"'
(A , B)
begindata
"k","\""我\"""
注解:如果是以逗号隔开的,那么其中有逗号就需要将整个字段用双引号引起来,有双引号的话就用双重双引号引起来。
结果