Skip to content

ALTER PUBLICATION

语法说明

ALTER PUBLICATION 修改发布内容。

语法结构

ALTER PUBLICATION pubname 
    [ACCOUNT 
            { ALL
            | account_name, [, ... ]
            | ADD account_name, [, ... ]
            | DROP account_name, [, ... ]]
    [COMMENT 'string']
    [DATABASE database_name]

语法解释

  • pubname:已存在的发布名称。
  • account_name:可获取该发布的实例名称。
  • database_name:要修改成的发布库名称。

示例

create database t;
create publication pub3 database t account 018fb939_e13e_7941_90bb_2aa52796xxxx;
alter publication pub3 account add 018fb99a_7c5a_78cb_8ac8_68881c12xxxx;

mysql> show create publication pub3;
+-------------+----------------------------------------------------------------------------------------------------------------------+
| Publication | Create Publication                                                                                                   |
+-------------+----------------------------------------------------------------------------------------------------------------------+
| pub3        | CREATE PUBLICATION pub3 DATABASE t ACCOUNT 018fb939_e13e_7941_90bb_2aa52796xxxx,018fb99a_7c5a_78cb_8ac8_68881c12xxxx |
+-------------+----------------------------------------------------------------------------------------------------------------------+
1 row in set (0.10 sec)

mysql> show publications;
+-------------+----------+---------------------+---------------------+---------------------------------------------------------------------------+----------+
| publication | database | create_time         | update_time         | sub_account                                                               | comments |
+-------------+----------+---------------------+---------------------+---------------------------------------------------------------------------+----------+
| pub3        | t        | 2024-05-27 10:57:09 | 2024-05-27 10:57:40 | 018fb939_e13e_7941_90bb_2aa52796xxxx,018fb99a_7c5a_78cb_8ac8_68881c12xxxx |          |
+-------------+----------+---------------------+---------------------+---------------------------------------------------------------------------+----------+
1 row in set (0.18 sec)

alter publication pub3  comment "this is pubs";--修改发布备注

mysql> show publications;
+-------------+----------+---------------------+---------------------+---------------------------------------------------------------------------+--------------+
| publication | database | create_time         | update_time         | sub_account                                                               | comments     |
+-------------+----------+---------------------+---------------------+---------------------------------------------------------------------------+--------------+
| pub3        | t        | 2024-05-27 10:57:09 | 2024-05-27 11:01:18 | 018fb939_e13e_7941_90bb_2aa52796xxxx,018fb99a_7c5a_78cb_8ac8_68881c12xxxx | this is pubs |
+-------------+----------+---------------------+---------------------+---------------------------------------------------------------------------+--------------+
1 row in set (0.23 sec)

create database new_pub3;
alter publication pub3 database new_pub3;--修改发布数据库

mysql> show publications;
+-------------+----------+---------------------+---------------------+---------------------------------------------------------------------------+--------------+
| publication | database | create_time         | update_time         | sub_account                                                               | comments     |
+-------------+----------+---------------------+---------------------+---------------------------------------------------------------------------+--------------+
| pub3        | new_pub3 | 2024-05-27 10:57:09 | 2024-05-27 11:02:07 | 018fb939_e13e_7941_90bb_2aa52796xxxx,018fb99a_7c5a_78cb_8ac8_68881c12xxxx | this is pubs |
+-------------+----------+---------------------+---------------------+---------------------------------------------------------------------------+--------------+
1 row in set (0.08 sec)