Skip to content

Latest commit

 

History

History
46 lines (30 loc) · 986 Bytes

sql-statement-cancel-import-job.md

File metadata and controls

46 lines (30 loc) · 986 Bytes
Raw
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 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