Skip to main content

SHOW DELETE

Description​

Queries historical DELETE operations that were successfully performed on Duplicate Key, Unique Key, and Aggregate tables in a specified database. For more information about data deletion, see DELETE.

Note that this command cannot be used to query DELETE operations that were performed on Primary Key tables.

Syntax​

SHOW DELETE [FROM <db_name>]

db_name: the database name, optional. If this parameter is not specified, the current database is used by default.

Return fields:

  • TableName: the table from which data is deleted.
  • PartitionName: the partition from which data is deleted. If the table is a non-partitioned table, * is displayed.
  • CreateTime: the time when the DELETE task was created.
  • DeleteCondition: the specified DELETE condition.
  • State: the status of the DELETE task.

Examples​

Show all historical DELETE operations of database.

SHOW DELETE FROM database;

+------------+---------------+---------------------+-----------------+----------+
| TableName  | PartitionName | CreateTime          | DeleteCondition | State    |
+------------+---------------+---------------------+-----------------+----------+
| mail_merge | *             | 2023-03-14 10:39:03 | name EQ "Peter" | FINISHED |
+------------+---------------+---------------------+-----------------+----------+