Skip to main content
Version: 2.5

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 |
+------------+---------------+---------------------+-----------------+----------+