PURGE

描述

该语句用于删除回收站中的数据库对象，支持删除数据库、表与索引。

语法

 PURGE {DATABASE | TABLE | INDEX} object_name;

object_name:
    database_name
  | table_name
  | index_name

参数解释

参数	描述
database_name	指定要删除的数据库在回收站中的名称，不支持直接指定数据库的名称。
table_name	指定要删除的表在回收站中的名称，不支持直接指定表的名称。
index_name	指定要删除的索引在回收站中的名称，不支持直接指定索引的名称。

示例

• 删除回收站中的数据库 __recycle_$_1_1597384386029184。

  CREATE DATABASE db1;
  Query OK, 1 row affected (0.410 sec)
  
  DROP DATABASE db1;
  Query OK, 0 rows affected (0.430 sec)
  
  SHOW RECYCLEBIN;
  +--------------------------------+---------------+----------+----------------------------+
  | OBJECT_NAME                    | ORIGINAL_NAME | TYPE     | CREATETIME                 |
  +--------------------------------+---------------+----------+----------------------------+
  | __recycle_$_1_1597384386029184 | db1           | DATABASE | 2020-08-14 13:53:06.029367 |
  +--------------------------------+---------------+----------+----------------------------+
  1 row in set (0.058 sec)
  
  PURGE DATABASE __recycle_$_1_1597384386029184;
  Query OK, 0 rows affected (0.470 sec)
  
  SHOW RECYCLEBIN;
  Empty set (0.068 sec)

• 删除回收站中的表 __recycle_$_1_1099511628776_1099511677778。

  CREATE TABLE test(c1 INT);
  Query OK, 0 rows affected (0.351 sec)
  
  DROP TABLE test;
  Query OK, 0 rows affected (0.411 sec)
  
  SHOW RECYCLEBIN;
  +-------------------------------------------+---------------+-------+----------------------------+
  | OBJECT_NAME                               | ORIGINAL_NAME | TYPE  | CREATETIME                 |
  +-------------------------------------------+---------------+-------+----------------------------+
  | __recycle_$_1_1099511628776_1099511677778 | test          | TABLE | 2017-10-20 17:40:22.304025 |
  +-------------------------------------------+---------------+-------+----------------------------+
  1 row in set (0.001 sec)
  
  PURGE TABLE __recycle_$_1_1099511628776_1099511677778;
  Query OK, 0 rows affected (0.415 sec)
  
  SHOW RECYCLEBIN;
  Empty set

• 删除回收站中的索引 __recycle_$_1_1597387726700872。

  CREATE TABLE t1(c1 INT);
  Query OK, 0 rows affected (0.315 sec)
  
  CREATE INDEX idx ON t1(c1);
  Query OK, 0 rows affected (0.319 sec)
  
  DROP TABLE t1;
  Query OK, 0 rows affected (0.115 sec)
  
  SHOW RECYCLEBIN;
  +--------------------------------+----------------------------+-------+----------------------------+
  | OBJECT_NAME                    | ORIGINAL_NAME              | TYPE  | CREATETIME                 |
  +--------------------------------+----------------------------+-------+----------------------------+
  | __recycle_$_1_1597387726700872 | __idx_1101710651081557_idx | INDEX | 2020-08-14 14:48:46.699145 |
  | __recycle_$_1_1597387726712976 | t1                         | TABLE | 2020-08-14 14:48:46.712643 |
  +--------------------------------+----------------------------+-------+----------------------------+
  2 rows in set (0.071 sec)
  
  PURGE INDEX __recycle_$_1_1597387726700872;
  Query OK, 0 rows affected (0.215 sec)
  
  SHOW RECYCLEBIN;
  +--------------------------------+----------------------------+-------+----------------------------+
  | OBJECT_NAME                    | ORIGINAL_NAME              | TYPE  | CREATETIME                 |
  +--------------------------------+----------------------------+-------+----------------------------+
  | __recycle_$_1_1597387726700872 | __idx_1101710651081557_idx | INDEX | 2020-08-14 14:48:46.699145 |
  +--------------------------------+----------------------------+-------+----------------------------+
  1 rows in set (0.091 sec)