Outdated Version
You are viewing an older version of this section. View current production version.
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.
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';
