CREATE PUBLICATION

Description

CREATE PUBLICATION adds a new publication into the current database.

Syntax

1. CREATE PUBLICATION pubname
2. DATABASE database_name ACCOUNT
3. [ { ALL
4. | account_name, [, ... ] }]
5. [ COMMENT 'string']

Explanations

  • pubname: The publication name. The publication name must be distinct from the name of any existing publication in the current database.
  • database_name: specifies the database name that exists under the current account.
  • account_name: The account name. The name of the account which obtains the publication.

Examples

1. create database t;
2. create account acc0 admin_name 'root' identified by '111';
3. create account acc1 admin_name 'root' identified by '111';
4. mysql> create publication pub1 database t account acc0,acc1;
5. Query OK, 0 rows affected (0.01 sec)

Constraints

MatrxiOne currently only supports publishing one database at a time.