源码:
load data
infile *
append into table AA
fields terminated by ‘,’
Optionally enclosed by ‘”’
(A , B)
begindata
“k”,”\”“我\”“”
结果:
k \”我\”
注解:如果是以逗号隔开的,那么其中有逗号就需要将整个字段用双引号引起来,有双引号的话就用双重双引号引起来。
同理如果用A作为分界符,那么包含A的话就用AA来表示。
load data
infile *
append into table AA
fields terminated by ‘,’
Optionally enclosed by ‘A’
(A , B)
begindata
AkA,A\AA我\AAA
结果:
k \A我\A