php[tek] – Making the most out of MySQL

Conference: php[tek] 2018

Location: Atlanta, USA

Language: English


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.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s