SHOW PUBLICATIONS

Description

Returns a list of all PUBLICATION names and corresponding database names.

For more information, you need have the authority of account administrator; check the system table mo_pubs for more parameters.

Syntax

  1. SHOW PUBLICATIONS;

Examples

  1. create account acc0 admin_name 'root' identified by '111';
  2. create account acc1 admin_name 'root' identified by '111';
  3. create account acc2 admin_name 'root' identified by '111';
  4. create database t;
  5. create publication pub3 database t account acc0,acc1;
  7. mysql> show publications;
  8. +------+----------+
  9. | Name | Database |
  10. +------+----------+
  11. | pub3 | t        |
  12. +------+----------+
  13. 1 row in set (0.00 sec)