PURGE

説明

このステートメントは、ごみ箱内のデータベースオブジェクトを削除するために使用されます。テナント、データベース、テーブル、インデックスの削除のみがサポートされています。

構文

 PURGE {TENANT | DATABASE | TABLE | INDEX} object_name;

object_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