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
CANCELIMPORTJOBJobID

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.

See also