CANCEL IMPORT

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

CANCEL IMPORT JOB - 图1

Note

This feature is not available on TiDB 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.

Synopsis

CancelImportJobsStmt

CANCEL IMPORT JOB - 图2

  1. CancelImportJobsStmt ::=
  2.     'CANCEL' 'IMPORT' 'JOB' JobID

Example

To cancel an import job with the ID as 1, execute the following statement:

  1. CANCEL IMPORT JOB 1;

The output is as follows:

  1. Query OK, 0 rows affected (0.01 sec)

MySQL compatibility

This statement is a TiDB extension to MySQL syntax.

See also