ALTER PUBLICATION

语法说明

ALTER PUBLICATION 将一个新的发布添加到当前数据库中。

语法结构

  1. ALTER PUBLICATION pubname ACCOUNT 
  2.     { ALL
  3.     | account_name, [, ... ]
  4.     | ADD account_name, [, ... ]
  5.     | DROP account_name, [, ... ]
  6.     [ COMMENT 'string']

语法解释

  • pubname：已存在的发布名称。
  • account_name：可获取该发布的租户名称。

示例

  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. show create publication pub3;
  8. Query OK, 0 rows affected (0.00 sec)
  10. mysql> show create publication pub3;
  11. +-------------+-----------------------------------------------------------------------+
  12. | Publication | Create Publication                                                    |
  13. +-------------+-----------------------------------------------------------------------+
  14. | pub3        | CREATE PUBLICATION `pub3` DATABASE `t` ACCOUNT `acc0`, `acc1`, `accx` |
  15. +-------------+-----------------------------------------------------------------------+
  16. 1 row in set (0.01 sec)
  18. mysql> show publications;
  19. +------+----------+
  20. | Name | Database |
  21. +------+----------+
  22. | pub3 | t        |
  23. +------+----------+
  24. 1 row in set (0.00 sec)