Spec-Zone .ru
спецификации, руководства, описания, API
|
MySQL applies these rules when various CREATE ... IF NOT EXISTS
statements are
replicated:
Every CREATE
DATABASE IF NOT EXISTS
statement is replicated, whether or not the database already exists on
the master.
Similarly, every CREATE
TABLE IF NOT EXISTS
statement without a SELECT
is replicated, whether or not the table already exists on the
master. This includes CREATE TABLE IF NOT
EXISTS ... LIKE
. Replication of CREATE TABLE IF NOT EXISTS ... SELECT
follows somewhat different
rules; see Section 16.4.1.5,
"Replication of CREATE TABLE ... SELECT
Statements", for more
information.
CREATE EVENT IF NOT
EXISTS
is always replicated in MySQL 5.6, whether or not the event named in the statement
already exists on the master.
See also Bug #45574.