CANCEL IMPORT

The CANCEL IMPORT statement is used to cancel a data import job created in TiDB.

Note

This feature is not available on TiDB Cloud Serverless clusters.

Required privileges

To cancel a data import job, you need to be the creator of the import job or have the SUPER privilege.

CancelImportJobsStmt ::=
    'CANCEL' 'IMPORT' 'JOB' JobID

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)

This statement is a TiDB extension to MySQL syntax.