Tag - strict mode

Upgrading to MySQL 5.7? Beware of the new STRICT mode

STRICT mode

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

MySQL

mysql> set global SQL_MODE=”NO_ENGINE_SUBSTITUTION”;

1

mysql> set global SQL_MODE=”NO_ENGINE_SUBSTITUTION”;

MySQL 5.7, dates and default values
The default
SQL_MODE in […]

Read more