is empty, all fields are unquoted. • Common values: – '"' quote fields with double-quote, same as RFC 4180 – '' disable quoting • Corresponds to the FIELDS ENCLOSED BY option in the LOAD DATA statement 3.1.5 Common configurations 5.3.1.5.1 CSV The default setting is already tuned for CSV following RFC 4180. [mydumper.csv] separator = ',' # It is not recommended to use the default ‘,’. It is �→ recommended is empty, all fields are unquoted. • Common values: – '"' quote fields with double-quote, same as RFC 4180 – '' disable quoting • Corresponds to the FIELDS ENCLOSED BY option in the LOAD DATA statement

is empty, all fields are unquoted. • Common values: – '"' quote fields with double-quote, same as RFC 4180 – '' disable quoting • Corresponds to the FIELDS ENCLOSED BY option in the LOAD DATA statement 3.1.5 Common configurations 5.3.1.5.1 CSV The default setting is already tuned for CSV following RFC 4180. [mydumper.csv] separator = ',' # It is not recommended to use the default ‘,’. It is �→ recommended is empty, all fields are unquoted. • Common values: – '"' quote fields with double-quote, same as RFC 4180 – '' disable quoting • Corresponds to the FIELDS ENCLOSED BY option in the LOAD DATA statement

is empty, all fields are unquoted. • Common values: – '"' quote fields with double-quote, same as RFC 4180 – '' disable quoting • Corresponds to the FIELDS ENCLOSED BY option in the LOAD DATA statement 3.1.5 Common configurations 5.3.1.5.1 CSV The default setting is already tuned for CSV following RFC 4180. [mydumper.csv] separator = ',' # It is not recommended to use the default ‘,’. It is �→ recommended is empty, all fields are unquoted. • Common values: – '"' quote fields with double-quote, same as RFC 4180 – '' disable quoting • Corresponds to the FIELDS ENCLOSED BY option in the LOAD DATA statement

BY 项。 5.4.1.3.2 delimiter • 指定引用定界符。 • 如果 delimiter 为空，所有字段都会被取消引用。 • 常用值： – '"' 使用双引号引用字段，和 RFC 4180 一致。 – '' 不引用 • 对应 LOAD DATA 语句中的 FIELDS ENCLOSED BY 项。 5.4.1.3.3 terminator • 指定行尾定界符。 • strict-format 被误设为 true，跨多行的单个完整字段会被分割成两部分，导 致解析失败，甚至不报错地导入已损坏的数据。 5.4.1.5 通用配置 5.4.1.5.1 CSV 默认设置已按照 RFC 4180 调整。 [mydumper.csv] separator = ',' # 如果数据中可能有逗号，建议源文件导出时分隔符使用非常见组合字符例如'|+|' delimiter = '"' TERMINATED BY 项。 delimiter • 指定引用定界符。 • 如果 delimiter 为空，所有字段都会被取消引用。 • 常用值： – '"' 使用双引号引用字段，和 RFC 4180 一致。 – '' 不引用 • 对应 LOAD DATA 语句中的 FIELDS ENCLOSED BY 项。 terminator • 指定行尾定界符。 • 如果 terminator

项。 131 5.4.1.3.2 delimiter • 指定引用定界符。 • 如果 delimiter 为空，所有字段都会被取消引用。 • 常用值： – '"' 使用双引号引用字段，和 RFC 4180 一致。 – '' 不引用 • 对应 LOAD DATA 语句中的 FIELDS ENCLOSED BY 项。 5.4.1.3.3 header • 是否所有 CSV 文件都包含表头行。 strict-format 被误设为 true，跨多行的单个完整字段会被分割成两部分，导 致解析失败，甚至不报错地导入已损坏的数据。 133 5.4.1.5 通用配置 5.4.1.5.1 CSV 默认设置已按照 RFC 4180 调整。 [mydumper.csv] separator = ',' # 如果数据中可能有逗号，建议源文件导出时分隔符使用非常见组合字符例如'|+|' delimiter = '"' TERMINATED BY 项。 delimiter • 指定引用定界符。 • 如果 delimiter 为空，所有字段都会被取消引用。 • 常用值： – '"' 使用双引号引用字段，和 RFC 4180 一致。 – '' 不引用 • 对应 LOAD DATA 语句中的 FIELDS ENCLOSED BY 项。 header • 是否所有 CSV 文件都包含表头行。 • 如为 true，第一行会被用作列名。如为

BY 项。 5.4.1.3.2 delimiter • 指定引用定界符。 • 如果 delimiter 为空，所有字段都会被取消引用。 • 常用值： – '"' 使用双引号引用字段，和 RFC 4180 一致。 – '' 不引用 • 对应 LOAD DATA 语句中的 FIELDS ENCLOSED BY 项。 5.4.1.3.3 terminator • 指定行尾定界符。 • strict-format 被误设为 true，跨多行的单个完整字段会被分割成两部分，导 致解析失败，甚至不报错地导入已损坏的数据。 5.4.1.5 通用配置 5.4.1.5.1 CSV 默认设置已按照 RFC 4180 调整。 [mydumper.csv] separator = ',' # 如果数据中可能有逗号，建议源文件导出时分隔符使用非常见组合字符例如'|+|' delimiter = '"' TERMINATED BY 项。 delimiter • 指定引用定界符。 • 如果 delimiter 为空，所有字段都会被取消引用。 • 常用值： – '"' 使用双引号引用字段，和 RFC 4180 一致。 – '' 不引用 • 对应 LOAD DATA 语句中的 FIELDS ENCLOSED BY 项。 terminator • 指定行尾定界符。 • 如果 terminator

Pipeline execution model. For more information about the resource control mechanism and parameters, see RFC: Global Resource Control in TiDB and TiFlash Resource Control. 8.5.5 How to use resource control also • CREATE RESOURCE GROUP 988 • ALTER RESOURCE GROUP • DROP RESOURCE GROUP • RESOURCE GROUP RFC 8.6 Time Zone Support The time zone in TiDB is decided by the global time_zone system variable and empty, all fields are unquoted. • Common values: • '"' quotes fields with double-quote. The same as RFC 4180. • '' disables quoting. • Corresponds to the FIELDS ENCLOSED BY option in the LOAD DATA statement

Pipeline execution model. For more information about the resource control mechanism and parameters, see RFC: Global Resource Control in TiDB and TiFlash Resource Control. 8.5.5 How to use resource control also • CREATE RESOURCE GROUP 1016 • ALTER RESOURCE GROUP • DROP RESOURCE GROUP • RESOURCE GROUP RFC 8.6 Time Zone Support The time zone in TiDB is decided by the global time_zone system variable and empty, all fields are unquoted. • Common values: • '"' quotes fields with double-quote. The same as RFC 4180. • '' disables quoting. • Corresponds to the FIELDS ENCLOSED BY option in the LOAD DATA statement

Pipeline execution model. For more information about the resource control mechanism and parameters, see RFC: Global Resource Control in TiDB and TiFlash Resource Control. 8.6.5 How to use resource control 11 See also • CREATE RESOURCE GROUP • ALTER RESOURCE GROUP • DROP RESOURCE GROUP • RESOURCE GROUP RFC 8.7 Time Zone Support The time zone in TiDB is decided by the time_zone system variable. You can empty, all fields are unquoted. • Common values: • '"' quotes fields with double-quote. The same as RFC 4180. • '' disables quoting. • Corresponds to the FIELDS ENCLOSED BY option in the LOAD DATA statement

Pipeline execution model. For more information about the resource control mechanism and parameters, see RFC: Global Resource Control in TiDB and TiFlash Resource Control. 8.6.5 How to use resource control also • CREATE RESOURCE GROUP 1035 • ALTER RESOURCE GROUP • DROP RESOURCE GROUP • RESOURCE GROUP RFC 8.7 Time Zone Support The time zone in TiDB is decided by the global time_zone system variable and empty, all fields are unquoted. • Common values: • '"' quotes fields with double-quote. The same as RFC 4180. • '' disables quoting. • Corresponds to the FIELDS ENCLOSED BY option in the LOAD DATA statement