New MySQL version, YAY!
MySQL 5.7 is full of new features, like virtual columns, virtual indexes and JSON fields! But, it came with some changes to the default configuration. When running:
What I want to talk about is the
mode. This mode rejects queries where nonaggregated columns are
expected, but aren’t on the
GROUP BY or
HAVING clause. Before MySQL 5.7.5,
ONLY_FULL_GROUP_BY was disabled by default, now it
You know the drill…
This is a simple statement, people use it everywhere, it shouldn’t be that hard to use, right?
Given the following schema:
Suppose I want to list all users that commented on …[Read more]