Sample Header Ad - 728x90

MySQL ZERO warnings

0 votes
1 answer
9157 views
I'm getting the error below in my MySQL log file. [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. How do I turn it off? Does turning the error off have an impact on my database? I'm on MySQL 5.7.14. My.ini contains this: sql-mode="STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER"
Asked by Dude (111 rep)
Aug 21, 2018, 06:46 AM
Last activity: Apr 8, 2025, 07:04 AM