In this post, you’ll learn more about the MariaDB Error 1722 ER_BINLOG_UNSAFE_WRITE_AUTOINC_SELECT with the details of the error message and why you receive this error
Maria DB Error Description
MariaDB Error 1722 – ER_BINLOG_UNSAFE_WRITE_AUTOINC_SELECT with the sqlState HY000
Error Description for the MariaDB Error ER_BINLOG_UNSAFE_WRITE_AUTOINC_SELECT
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 master and the slave.