CSV files from MySQL, see Export to CSV files using Dumpling. TiDB Lightning supports reading CSV (comma-separated values) data source, as well as other delimited format such as TSV (tab-separated values) separator. • Can be multiple characters, but must not be empty. • Common values: – ',' for CSV (comma-separated values) – "\t" for TSV (tab-separated values) – "\u0001" to use the ASCII character 0x01 statement. 5.3.1.3.7 trim-last-separator • Treats the field separator as a terminator, and removes all trailing separators. For example, with the CSV file: 188 A,,B,, • When trim-last-separator = false, this

CSV files from MySQL, see Export to CSV files using Dumpling. TiDB Lightning supports reading CSV (comma-separated values) data source, as well as other delimited format such as TSV (tab-separated values) separator. • Can be multiple characters, but must not be empty. • Common values: – ',' for CSV (comma-separated values) – "\t" for TSV (tab-separated values) – "\u0001" to use the ASCII character 0x01 statement. 5.3.1.3.7 trim-last-separator • Treats the field separator as a terminator, and removes all trailing separators. For example, with the CSV file: 176 A,,B,, • When trim-last-separator = false, this

than one table, each is separated by a comma. 554 • INDEX_NAMES: All SQL indexes used in SQL statements. If there is more than one index, each is separated by a comma. • SAMPLE_USER: The users who execute format of the field is type:number. If there is more than one error type, each is separated by a comma, like txnLock:2,pdRPC:1. • AVG_AFFECTED_ROWS: The average number of rows affected. • PREV_SAMPLE_TEXT: ColumnNameList specifies the name list of the target columns. If you need to specify more than one column, use comma , to separate the column names. For example, ANALYZE table t columns a, b. Besides collecting statistics

CSV files from MySQL, see Export to CSV files using Dumpling. TiDB Lightning supports reading CSV (comma-separated values) data source, as well as other delimited format such as TSV (tab-separated values) separator. • Can be multiple characters, but must not be empty. • Common values: – ',' for CSV (comma-separated values) – "\t" for TSV (tab-separated values) – "\u0001" to use the ASCII character 0x01 statement. 5.3.1.3.6 trim-last-separator • Treats the field separator as a terminator, and removes all trailing separators. For example, with the CSV file: A,,B,, • When trim-last-separator = false, this is

{elements} ); Parameter description • {table_name}: The name of the table to be created. • {elements}: A comma-separated list of table elements, such as column definitions and primary key definitions. Suppose than one table, each is separated by a comma. • INDEX_NAMES: All SQL indexes used in SQL statements. If there is more than one index, each is separated by a comma. • SAMPLE_USER: The users who execute format of the field is type:number. If there is more than one error type, each is separated by a comma, like txnLock:2,pdRPC:1. • AVG_AFFECTED_ROWS: The average number of rows affected. • PREV_SAMPLE_TEXT:

DATETIME #48814 @crazycs520 • Fix the issue that using the _ wildcard in LIKE when the data contains trailing spaces can result in incorrect query results #48983 @time-and-fate • Fix the issue that high CPU {elements} ); Parameter description • {table_name}: The name of the table to be created. • {elements}: A comma-separated list of table elements, such as column definitions and primary key definitions. Suppose than one table, each is separated by a comma. • INDEX_NAMES: All SQL indexes used in SQL statements. If there is more than one index, each is separated by a comma. • SAMPLE_USER: The users who execute

{elements} ); Parameter description • {table_name}: The name of the table to be created. • {elements}: A comma-separated list of table elements, such as column definitions and primary key definitions. 351 Suppose than one table, each is separated by a comma. • INDEX_NAMES: All SQL indexes used in SQL statements. If there is more than one index, each is separated by a comma. • SAMPLE_USER: The users who execute format of the field is type:number. If there is more than one error type, each is separated by a comma, like txnLock:2,pdRPC:1. • AVG_AFFECTED_ROWS: The average number of rows affected. • PREV_SAMPLE_TEXT:

{elements} ); Parameter description • {table_name}: The name of the table to be created. • {elements}: A comma-separated list of table elements, such as column definitions and primary key definitions. 332 Suppose than one table, each is separated by a comma. • INDEX_NAMES: All SQL indexes used in SQL statements. If there is more than one index, each is separated by a comma. • SAMPLE_USER: The users who execute format of the field is type:number. If there is more than one error type, each is separated by a comma, like txnLock:2,pdRPC:1. • AVG_AFFECTED_ROWS: The average number of rows affected. • PREV_SAMPLE_TEXT:

{elements} ); Parameter description • {table_name}: The name of the table to be created. • {elements}: A comma-separated list of table elements, such as column definitions and primary key definitions. 352 Suppose than one table, each is separated by a comma. • INDEX_NAMES: All SQL indexes used in SQL statements. If there is more than one index, each is separated by a comma. • SAMPLE_USER: The users who execute format of the field is type:number. If there is more than one error type, each is separated by a comma, like txnLock:2,pdRPC:1. • AVG_AFFECTED_ROWS: The average number of rows affected. • PREV_SAMPLE_TEXT:

{elements} ); Parameter description • {table_name}: The name of the table to be created. • {elements}: A comma-separated list of table elements, such as column definitions and primary key definitions. Suppose than one table, each is separated by a comma. • INDEX_NAMES: All SQL indexes used in SQL statements. If there is more than one index, each is separated by a comma. • SAMPLE_USER: The users who execute format of the field is type:number. If there is more than one error type, each is separated by a comma, like txnLock:2,pdRPC:1. • AVG_AFFECTED_ROWS: The average number of rows affected. • PREV_SAMPLE_TEXT: