MySQL 5.6 introduced the fractional second precision for temporal data types –
TIMESTAMP, with up to microseconds (6 digits) precision. Along with providing fractional second precision, the new implementation for temporals is disk efficient.
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.…
In 5.7.5, as a part of the larger effort to improve error handling, we re-implemented the IGNORE clause (WL#6614). The IGNORE clause is a MySQL extension to the SQL standard. It affects the errors which occur for each row.…