MySQL error code
MySQL error 1722
MySQL server error 1722 is ER_BINLOG_UNSAFE_WRITE_AUTOINC_SELECT, reported with SQLSTATE HY000.
Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on source and the replica.
| Error | 1722 |
|---|---|
| Name | ER_BINLOG_UNSAFE_WRITE_AUTOINC_SELECT |
| SQLSTATE | HY000 |
| Group | Server errors |
Source: MySQL 8.4 Error Reference