首批通过分布式安全可靠测评，为关键业务系统打造
PURGE
更新时间：2023-08-01 14:14:04
编辑
分享
描述
该语句用于删除回收站中的数据库对象，只支持删除租户、数据库、表与索引。
语法
PURGE {TENANT | DATABASE | TABLE | INDEX} object_name;
object_name:
tenant_name
| database_name
| table_name
| index_name
参数解释
| 参数 | 描述 |
|---|---|
| tenant_name | 指定要删除的租户名称。 可以使用删除前的原始租户名，也可以使用在回收站中的名字。回收站中的名字具有唯一性，可以指定确定的租户；原始租户名可能会重复，此时删除的是最早进入回收站的租户。 |
| database_name | 指定要删除的数据库在回收站中的名称，不支持直接指定数据库的名称。 |
| table_name | 指定要删除的表在回收站中的名称，不支持直接指定表的名称。 |
| index_name | 指定要删除的索引在回收站中的名称，不支持直接指定索引的名称。 |
示例
删除回收站中的租户
mysql。obclient> SHOW RECYCLEBIN; +--------------------------------+---------------+--------+----------------------------+ | OBJECT_NAME | ORIGINAL_NAME | TYPE | CREATETIME | +--------------------------------+---------------+--------+----------------------------+ | __recycle_$_1_1599722585571328 | mysql | TENANT | 2020-09-10 15:36:54.712101 | +--------------------------------+---------------+--------+----------------------------+ 1 row in set obclient> PURGE TENANT mysql; Query OK, 0 rows affected obclient> SHOW RECYCLEBIN; Empty set删除回收站中的数据库
__recycle_$_1_1597384386029184。obclient> CREATE DATABASE db1; Query OK, 1 row affected obclient> DROP DATABASE db1; Query OK, 0 rows affected obclient> SHOW RECYCLEBIN; +--------------------------------+---------------+----------+----------------------------+ | OBJECT_NAME | ORIGINAL_NAME | TYPE | CREATETIME | +--------------------------------+---------------+----------+----------------------------+ | __recycle_$_1_1597384386029184 | db1 | DATABASE | 2020-08-14 13:53:06.029367 | +--------------------------------+---------------+----------+----------------------------+ 1 row in set obclient> PURGE DATABASE __recycle_$_1_1597384386029184; Query OK, 0 rows affected obclient> SHOW RECYCLEBIN; Empty set删除回收站中的表
__recycle_$_1_1099511628776_1099511677778。obclient> CREATE TABLE test(c1 INT); Query OK, 0 rows affected obclient> DROP TABLE test; Query OK, 0 rows affected obclient> 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 obclient> PURGE TABLE __recycle_$_1_1099511628776_1099511677778; Query OK, 0 rows affected obclient> SHOW RECYCLEBIN; Empty set删除回收站中的索引
__recycle_$_1_1597387726700872。obclient> CREATE TABLE t1(c1 INT); Query OK, 0 rows affected obclient> CREATE INDEX idx ON t1(c1); Query OK, 0 rows affected obclient> DROP TABLE t1; Query OK, 0 rows affected obclient> 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 obclient> PURGE INDEX __recycle_$_1_1597387726700872; Query OK, 0 rows affected obclient> 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
