MySQL's JSON Data Type

A session at php[tek] 2016

Friday 27th May, 2016

10:30am to 11:30am (CST)

MySQL 5.7 features native JSON data types so you can store valid JSON docs in your MySQL instances. The bad news is that there are many functions for creating, searching, modifying, and testing all this JSON data. Plus, you need to learn about generated columns to efficiently use JSON data in SQL indexes for fast searches. This presentation covers what a PHP code developer NEEDS to know to effectively use JSON with MySQL and to understand when JSON may not be optimal.

About the speaker

This person is speaking at this event.

MySQL Community Manager

Sign in to add slides, notes or videos to this session

Tell your friends!


Time 10:30am11:30am CST

Date Fri 27th May 2016

Short URL


Official session page


View the schedule


See something wrong?

Report an issue with this session