sql-statement-cancel-import-job.md

title	summary
CANCEL IMPORT	An overview of the usage of CANCEL IMPORT in TiDB.

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.

Synopsis

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.

See also

• IMPORT INTO
• SHOW IMPORT JOB