Tag - sql_mode

Solve Query Failures Regarding ONLY_FULL_GROUP_BY SQL Mode

Solve Query Failures SQL mode

“Hey, what’s going on with my applications? I installed a newer version of MySQL. I have queries that perfectly run with the older version and now I have a lot of errors.”
This is a question some customers have asked me after upgrading MySQL. In this article, we’ll see what one of the most frequent […]

Read more

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