MySQL Error 1723 – ER_BINLOG_UNSAFE_CREATE_SELECT_AUTOINC

MySQL Error Message

CREATE TABLE… SELECT… on a table with an
auto-increment column is unsafe because the order in which rows
are retrieved by the SELECT determines which (if any) rows are
inserted. This order cannot be predicted and may differ on source
and the replica.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

MySQL Error Message Could not read CA key file: %s Reason for the Error ER_X509_CANT_READ_CA_KEY was added in 8.0.2.
MySQL Error Message Read invalid event from master: ‘%s’, master could be corrupt but a more likely cause of this...
MySQL Error Message %s Reason for the Error ER_IB_MSG_315 was added in 8.0.11.