SHOW SUBSCRIPTIONS

语法说明

返回所有订阅库名称列表与来源租户名。

语法结构

1. SHOW SUBSCRIPTIONS;

示例

1. mysql> create database sub1 from sys publication sys_pub_1;
2. Query OK, 1 row affected (0.02 sec)

4. mysql> show subscriptions;
5. +------+--------------+
6. | Name | From_Account |
7. +------+--------------+
8. | sub1 | sys          |
9. +------+--------------+
10. 1 row in set (0.01 sec)