Skip to content

SHOW SUBSCRIPTIONS

语法说明

返回所有发布名、发布实例名、发布的数据库名、发布给该租户的时间、订阅名和创建该订阅的时间。

语法结构

SHOW SUBSCRIPTIONS [ALL];

语法解释

  • ALL 选项可以看到所有有权限的订阅，未订阅的 sub_time, sub_name 为 null，不加 ALL 只能看到已订阅的发布信息。

示例

mysql> show subscriptions all;
+--------------------------+--------------------------------------+--------------------------+---------------------+----------+----------+
| pub_name                 | pub_account                          | pub_database             | pub_time            | sub_name | sub_time |
+--------------------------+--------------------------------------+--------------------------+---------------------+----------+----------+
| pub_mall                 | 018fb8d3_2b05_7be8_b526_bb62576dxxxx | new_pub                  | 2024-05-27 09:46:59 | NULL     | NULL     |
| pub_school               | 018fb8d3_2b05_7be8_b526_bb62576dxxxx | school                   | 2024-05-27 09:20:13 | NULL     | NULL     |
+--------------------------+--------------------------------------+--------------------------+---------------------+----------+----------+
22 rows in set (0.10 sec)


mysql> show subscriptions;
Empty set (0.00 sec)

mysql>  create database sub1 from 018fb8d3_2b05_7be8_b526_bb62576dxxxx publication pub_school; 
Query OK, 1 row affected (0.02 sec)

mysql> show subscriptions all;
+--------------------------+--------------------------------------+--------------------------+---------------------+----------+---------------------+
| pub_name                 | pub_account                          | pub_database             | pub_time            | sub_name | sub_time            |
+--------------------------+--------------------------------------+--------------------------+---------------------+----------+---------------------+
| pub_school               | 018fb8d3_2b05_7be8_b526_bb62576dxxxx | school                   | 2024-05-27 09:20:13 | sub1     | 2024-05-27 10:39:12 |
| pub_mall                 | 018fb8d3_2b05_7be8_b526_bb62576dxxxx | new_pub                  | 2024-05-27 09:46:59 | NULL     | NULL                |
+--------------------------+--------------------------------------+--------------------------+---------------------+----------+---------------------+

mysql> show subscriptions;
+------------+--------------------------------------+--------------+---------------------+----------+---------------------+
| pub_name   | pub_account                          | pub_database | pub_time            | sub_name | sub_time            |
+------------+--------------------------------------+--------------+---------------------+----------+---------------------+
| pub_school | 018fb8d3_2b05_7be8_b526_bb62576dxxxx | school       | 2024-05-27 09:20:13 | sub1     | 2024-05-27 10:39:12 |
+------------+--------------------------------------+--------------+---------------------+----------+---------------------+
1 row in set (0.08 sec)