mysql-load导入时设置的enclose、escape不生效

👨🏻‍💻 技术问答 数据导入&导出
1

使用mysql-load导入时设置的enclose、escape不生效

load data local
infile ‘/data/sss/bin/test.sql’
into table test.order_202310
columns terminated by ‘,’
lines terminated by ‘\n’
PROPERTIES (“trim_double_quotes”=“true”,“enclose”=“"”,“escape”=“\”)
;