backslash-escape = true trim-last-separator = false Example content: 168 ID,Region,Count 1,"East",32 2,"South",\N 3,"West",10 4,"North",39 5.3.1.5.2 TSV [mydumper.csv] separator = "\t" delimiter = '' header backslash-escape = false trim-last-separator = false Example content: ID Region Count 1 East 32 2 South NULL 3 West 10 4 North 39 5.3.1.5.3 TPC-H DBGEN [mydumper.csv] separator = '|' delimiter = '' not-null = true backslash-escape = false trim-last-separator = true Example content: 1|East|32| 2|South|0| 3|West|10| 4|North|39| 5.3.2 LOAD DATA The LOAD DATA statement batch loads data into a TiDB table

not-null = false null = '\N' backslash-escape = true Example content: ID,Region,Count 1,"East",32 2,"South",\N 3,"West",10 4,"North",39 5.3.1.5.2 TSV [mydumper.csv] separator = "\t" delimiter = '' header false null = 'NULL' backslash-escape = false Example content: 190 ID Region Count 1 East 32 2 South NULL 3 West 10 4 North 39 5.3.1.5.3 TPC-H DBGEN [mydumper.csv] separator = '|' delimiter = '' terminator = "|\n" header = false not-null = true backslash-escape = false Example content: 1|East|32| 2|South|0| 3|West|10| 4|North|39| 5.3.2 LOAD DATA The LOAD DATA statement batch loads data into a TiDB table

not-null = false null = '\N' backslash-escape = true Example content: ID,Region,Count 1,"East",32 2,"South",\N 3,"West",10 4,"North",39 5.3.1.5.2 TSV [mydumper.csv] separator = "\t" delimiter = '' header false null = 'NULL' backslash-escape = false Example content: 178 ID Region Count 1 East 32 2 South NULL 3 West 10 4 North 39 5.3.1.5.3 TPC-H DBGEN [mydumper.csv] separator = '|' delimiter = '' terminator = "|\n" header = false not-null = true backslash-escape = false Example content: 1|East|32| 2|South|0| 3|West|10| 4|North|39| 5.3.2 LOAD DATA The LOAD DATA statement batch loads data into a TiDB table

not-null = false null = '\N' backslash-escape = true 示例内容： ID,Region,Count 1,"East",32 2,"South",\N 3,"West",10 4,"North",39 5.4.1.5.2 TSV 140 [mydumper.csv] separator = "\t" delimiter = not-null = false null = 'NULL' backslash-escape = false 示例内容： ID Region Count 1 East 32 2 South NULL 3 West 10 4 North 39 5.4.1.5.3 TPC-H DBGEN [mydumper.csv] separator = '|' delimiter = '' terminator = "|\n" header = false not-null = true backslash-escape = false 示例内容： 1|East|32| 2|South|0| 3|West|10| 4|North|39| 5.4.2 LOAD DATA LOAD DATA 语句用于将数据批量加载到 TiDB 表中。 5.4.2.1 语法图 LoadDataStmt

'\N' backslash-escape = true trim-last-separator = false 示例内容： ID,Region,Count 1,"East",32 2,"South",\N 3,"West",10 4,"North",39 5.4.1.5.2 TSV [mydumper.csv] separator = "\t" delimiter = '' header 'NULL' backslash-escape = false trim-last-separator = false 示例内容： ID Region Count 1 East 32 2 South NULL 3 West 10 4 North 39 5.4.1.5.3 TPC-H DBGEN [mydumper.csv] separator = '|' 134 delimiter false not-null = true backslash-escape = false trim-last-separator = true 示例内容： 1|East|32| 2|South|0| 3|West|10| 4|North|39| 5.4.2 LOAD DATA LOAD DATA 语句用于将数据批量加载到 TiDB 表中。 5.4.2.1 语法图 LoadDataStmt

not-null = false null = '\N' backslash-escape = true 示例内容： ID,Region,Count 1,"East",32 2,"South",\N 3,"West",10 4,"North",39 5.4.1.5.2 TSV 148 [mydumper.csv] separator = "\t" delimiter = not-null = false null = 'NULL' backslash-escape = false 示例内容： ID Region Count 1 East 32 2 South NULL 3 West 10 4 North 39 5.4.1.5.3 TPC-H DBGEN [mydumper.csv] separator = '|' delimiter = '' terminator = "|\n" header = false not-null = true backslash-escape = false 示例内容： 1|East|32| 2|South|0| 3|West|10| 4|North|39| 5.4.2 LOAD DATA LOAD DATA 语句用于将数据批量加载到 TiDB 表中。 5.4.2.1 语法图 LoadDataStmt

example changes for common formats: TSV: ### Format example ### ID Region Count ### 1 East 32 ### 2 South NULL ### 3 West 10 ### 4 North 39 ### Format configuration 257 [mydumper.csv] separator = "\t" backslash-escape = false trim-last-separator = false TPC-H DBGEN: ### Format example ### 1|East|32| ### 2|South|0| ### 3|West|10| ### 4|North|39| ### Format configuration [mydumper.csv] separator = '|' delimiter not-null = false null = '\N' backslash-escape = true Example content: ID,Region,Count 1,"East",32 2,"South",\N 3,"West",10 4,"North",39 TSV [mydumper.csv] separator = "\t" delimiter = '' header = true not-null

example changes for common formats: TSV: ### Format example ### ID Region Count ### 1 East 32 ### 2 South NULL ### 3 West 10 ### 4 North 39 695 ### Format configuration [mydumper.csv] separator = "\t" backslash-escape = false trim-last-separator = false TPC-H DBGEN: ### Format example ### 1|East|32| ### 2|South|0| ### 3|West|10| ### 4|North|39| ### Format configuration [mydumper.csv] separator = '|' delimiter false null = '\N' backslash-escape = true Example content: 2047 ID,Region,Count 1,"East",32 2,"South",\N 3,"West",10 4,"North",39 TSV [mydumper.csv] separator = "\t" delimiter = '' header = true not-null

[mydumper.csv] 格 式定义同样需要做相应修改。常见的格式修改如下： TSV： ### 格式示例 ### ID Region Count ### 1 East 32 ### 2 South NULL ### 3 West 10 ### 4 North 39 ### 格式配置 [mydumper.csv] separator = "\t" delimiter = '' header backslash-escape = false trim-last-separator = false TPC-H DBGEN： ### 格式示例 ### 1|East|32| ### 2|South|0| ### 3|West|10| ### 4|North|39| ### 格式配置 [mydumper.csv] separator = '|' delimiter = '' header not-null = false null = '\N' backslash-escape = true 示例内容： ID,Region,Count 1,"East",32 2,"South",\N 3,"West",10 4,"North",39 TSV [mydumper.csv] separator = "\t" delimiter = '' header = true

violence can have their cases heard faster. We’re securing commitments and supporting partners in South and Central �→ America to host more refugees and secure their own borders. -------------------- violence can have their cases heard faster. We’re securing commitments and supporting partners in South and Central �→ America to host more refugees and secure their own borders. -------------------- example changes for common formats: TSV: ### Format example ### ID Region Count ### 1 East 32 ### 2 South NULL ### 3 West 10 ### 4 North 39 ### Format configuration [mydumper.csv] separator = "\t" delimiter