SHOW PUBLICATIONS

Grammar Description

Returns all publish names, published database names, publish creation time, publish latest modification time, publish specified instance names (if all, display "*") and notes.

Grammar Structure

SHOW PUBLICATIONS;

Example

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)