CANCEL IMPORT
The CANCEL IMPORT statement is used to cancel a data import job created in TiDB.
Required privileges
To cancel a data import job, you need to be the creator of the import job or have the SUPER privilege.
Synopsis
- CancelImportJobsStmt
CancelImportJobsStmt ::=
'CANCEL' 'IMPORT' 'JOB' JobID
Example
To cancel an import job with the ID as 1, execute the following statement:
CANCEL IMPORT JOB 1;
The output is as follows:
Query OK, 0 rows affected (0.01 sec)
MySQL compatibility
This statement is a TiDB extension to MySQL syntax.