3 ms·
The docs describe a lot of ways data can be corrupted if you don't have the right configuration and database engine: https://dev.mysql.com/doc/refman/5.7/en/co
by nathan_long 10y ago
The docs describe a lot of ways data can be corrupted if you don't have the right configuration and database engine:
https://dev.mysql.com/doc/refman/5.7/en/constraint-invalid-data.html https://dev.mysql.com/doc/refman/5.7/en/constraint-invalid-d...
- tveita 10y agoI don't think any of those apply in strict mode, which is the default in recent versions of MySQL. https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html "The default SQL mode in MySQL 5.7 includes these modes: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, and NO_ENGINE_SUBSTITUTION."