从CSV文件中加载数据，其中双引号用作转义字符

根据的文档

LOADDATA

如果字段以ENCLOSED BY字符开头，则只有当该字段或行的TERMINATED
BY序列紧随其后，该字符的实例才被视为终止字段值。为避免歧义，可以将字段值中ENCLOSED
BY字符的出现次数加倍，并解释为该字符的单个实例。例如，如果指定了ENCLOSED BY’“’，则引号的处理如下所示：

"The ""BIG"" boss"  -> The "BIG" bossThe "BIG" boss      -> The "BIG" bossThe ""BIG"" boss    -> The ""BIG"" boss

因此，我需要做的就是

ESCAPED BY ''

LOAD DATA  LOCAL INFILE 'temp-1.csv'  INTO TABLE person  FIELDS    TERMINATED BY ','    ENCLOSED BY '"'    ESCAPED BY ''  LINES    TERMINATED BY 'n'  IGNORE 1 LINES;