Beware of the new STRICT mode when you are upgrading to MySQL 5.7.md 529 B


Title: "Beware of the new STRICT mode when you are upgrading to MySQL 5.7" Categories: [data base] Date: 2017-07-02 22:01:40 tags: [percona, mysql, mariadb]

Authors: sedlav

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).

Link