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.