MySQL 5.6 introduced the fractional second precision for temporal data types – TIME
, DATETIME
, and TIMESTAMP
, with up to microseconds (6 digits) precision. Along with providing fractional second precision, the new implementation for temporals is disk efficient.
All posts by Abhishek Ranjan
Improvements to STRICT MODE in MySQL
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.…
Improvements to the MySQL `IGNORE` Implementation
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.…