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)