As a part of improving the error handling, in MySQL 5.7.5 we have re-implemented STRICT sql mode.
STRICT mode in MySQL affects the errors that arise from invalid, missing, or out of range values in DML statements such as INSERT, UPDATE, and DELETE. The new implementation aims to make the behavior of STRICT mode more consistent, yet maintain backward compatibility as much as possible.
In MySQL 5.7.5, we have made three general improvements to STRICT mode behavior:
1. STRICT mode got simpler
It was observed that having a large number of sql modes dependent on STRICT mode creates confusion among users. Specifically, we are talking about NO_ZERO_DATE, NO_ZERO_IN_DATE and ERROR_FOR_DIVISION_BY_ZERO modes. You can se further details on the above sql modes here. These modes only …[Read more]