CLEAR LOAD ERRORS

Removes load errors from the information_schema.LOAD_DATA_ERRORS table. These errors are populated by LOAD DATA ... ERRORS HANDLE <string> when it runs.

Syntax

CLEAR LOAD ERRORS [ HANDLE string ]

Remarks

  • CLEAR LOAD ERRORS removes all records from the information_schema.LOAD_DATA_ERRORS table.

  • CLEAR LOAD ERRORS [ HANDLE string ] removes records from the information_schema.LOAD_DATA_ERRORS table where the HANDLE field matches the string value that you specify.

  • This command causes implicit commits. Refer to COMMIT for more information.

Example

Suppose the INFORMATION_SCHEMA.LOAD_DATA_ERRORS table contains many records. Two of these records have the handle orders_errors:

SELECT load_data_line_number, load_data_line, error_message
FROM INFORMATION_SCHEMA.LOAD_DATA_ERRORS
WHERE handle = 'orders_errors'
ORDER BY load_data_line_number;
+-----------------------+-----------------------------+--------------------------------------------------------------+
| load_data_line_number | load_data_line              | error_message                                                |
+-----------------------+-----------------------------+--------------------------------------------------------------+
|                     2 | 2,138,Pears,{"order-date"}  | Invalid JSON value for column 'order_properties'             |
|                     4 | 4,307,Oranges,\N            | NULL supplied to NOT NULL column 'order_properties' at row 4 |
+-----------------------+-----------------------------+--------------------------------------------------------------+

To remove the two records, run the following command.

CLEAR LOAD ERRORS HANDLE 'orders_errors';

Last modified: July 25, 2022

Was this article helpful?