SHOW CREATE PUBLICATION

语法说明

返回 PUBLICATION 创建时的 SQL 语句。

语法结构

  1. SHOW CREATE PUBLICATION pubname;

示例

  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;
  6. mysql> alter publication pub3 account add accx;
  7. Query OK, 0 rows affected (0.00 sec)
  9. mysql> show create publication pub3;
  10. +-------------+-----------------------------------------------------------------------+
  11. | Publication | Create Publication                                                    |
  12. +-------------+-----------------------------------------------------------------------+
  13. | pub3        | CREATE PUBLICATION `pub3` DATABASE `t` ACCOUNT `acc0`, `acc1`, `accx` |
  14. +-------------+-----------------------------------------------------------------------+
  15. 1 row in set (0.01 sec)