Link You Today
Bookmark your Free, Libre software & tech link

Beware of the new STRICT mode when you are upgrading to MySQL 5.7

mariadb, mysql, percona

This blog post discusses the ramifications of STRICT mode in MySQL 5.7. By default, MySQL 5.7 is much “stricter” than older versions of MySQL. To temporarily fix this, change the SQL_MODE to NO_ENGINE_SUBSTITUTION (same as in MySQL 5.6).