SHOW PUBLICATIONS

语法说明

返回所有发布名、发布的数据库名、发布创建时间、发布最新修改时间、发布指定的实例名列表（如果是所有则展示 "*"）和备注。

语法结构

SHOW PUBLICATIONS;

示例

create database t;
create publication pub3 database t account 018fb99a_7c5a_78cb_8ac8_68881c12xxxx,018fb939_e13e_7941_90bb_2aa52796xxxx;

mysql> show publications;
+-------------+----------+---------------------+-------------+---------------------------------------------------------------------------+----------+
| publication | database | create_time         | update_time | sub_account                                                               | comments |
+-------------+----------+---------------------+-------------+---------------------------------------------------------------------------+----------+
| pub3        | t        | 2024-05-27 11:11:55 | NULL        | 018fb939_e13e_7941_90bb_2aa52796xxxx,018fb99a_7c5a_78cb_8ac8_68881c12xxxx |          |
+-------------+----------+---------------------+-------------+---------------------------------------------------------------------------+----------+
1 row in set (0.16 sec)