MySQL 5.7 is two years old, and adoption is growing. The new JSON data type shines as the most talked feature in this version. But, they are by no means the only awesome thing it has to offer.

Learn how to manipulate JSON fields and how generated columns can help you index data and more. This talk will teach you how to properly do a _GROUP BY_ without being stuck in the new default mode of MySQL 5.7. Changing the default won't solve your problem. It's a temporary fix to hide something much more significant: the code that needs to be fixed.

Generated columns are a concept available in databases such as Oracle and MS SQL Sever. MySQL, however, is one of the biggest open source databases to implement it and this is very helpful when using JSON data types.

Knowledge of JSON data type is required for this talk.


Comments are closed.

I got caught by the GROUP BY change before too. Generated columns is one of the new features i'm looking forward to using. Interesting coverage of the changes in versions up to 5.7.

Amazing talk and demos, many thx :)

Chance Garcia at 12:12 on 1 Jun 2018

Awesome talk and the demos really helped to solidify things in my mind.

Thanks for the useful examples.

Ravi Gehlot at 00:09 on 2 Jun 2018

Thank you!