Talk in English - US at php[tek] 2018
View Slides: https://www.slideshare.net/gabidavila/making-the-most-out-of-mysql-99942457
Short URL: https://joind.in/talk/8edff (QR-Code (opens in new window))
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.