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 |
+----------+-------------+--------------+---------------------+----------+----------+
| pub3     | sys         | t            | 2024-04-23 11:11:06 | NULL     | NULL     |
+----------+-------------+--------------+---------------------+----------+----------+
1 row in set (0.01 sec)

mysql> show subscriptions;
Empty set (0.00 sec)

mysql>  create database sub3 from sys publication pub3;
Query OK, 1 row affected (0.02 sec)

mysql> show subscriptions all;
+----------+-------------+--------------+---------------------+----------+---------------------+
| pub_name | pub_account | pub_database | pub_time            | sub_name | sub_time            |
+----------+-------------+--------------+---------------------+----------+---------------------+
| pub3     | sys         | t            | 2024-04-23 11:11:06 | sub3     | 2024-04-23 11:12:11 |
+----------+-------------+--------------+---------------------+----------+---------------------+
1 row in set (0.00 sec)

mysql> show subscriptions;
+----------+-------------+--------------+---------------------+----------+---------------------+
| pub_name | pub_account | pub_database | pub_time            | sub_name | sub_time            |
+----------+-------------+--------------+---------------------+----------+---------------------+
| pub3     | sys         | t            | 2024-04-23 11:11:06 | sub3     | 2024-04-23 11:12:11 |
+----------+-------------+--------------+---------------------+----------+---------------------+
1 row in set (0.01 sec)