How to resolve the «'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' "sql modes should be used with strict mode» MySQL warning?

mysql

(Dmitry Fedyuk) #1

Locate the following line in the my.ini / my.cnf:

sql-mode=<...>

Add the mentioned constants to it:

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO"