MYSQL导入文件带双引号问题
时间:2021-07-01 10:21:17
帮助过:22人阅读
into table test_info
fields terminated by ‘,‘ optionally enclosed by ‘"‘ escaped by ‘"‘
lines terminated by ‘\r\n‘;
fields terminated by ‘,‘ 分隔符
optionally enclosed by ‘"‘ 去掉包围数字的双引号
lines terminated by ‘\r\n‘ 行尾符
MYSQL导入文件带双引号问题
标签:tmp bsp test 双引号 table ted key min inf