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 …[Read more...]