草庐IT

Mysql 警告代码 1592 使用语句格式写入二进制日志的不安全语句

Note(Code1592):UnsafestatementwrittentothebinarylogusingstatementformatsinceBINLOG_FORMAT=STATEMENT.Statementswritingtoatablewithanauto-incrementcolumnafterselectingfromanothertableareunsafebecausetheorderinwhichrowsareretrieveddetermineswhat(ifany)rowswillbewritten.Thisordercannotbepredictedand