Image

3

Finding the Path

The server checks to make sure this data bound for the JSON data type column is in a valid JSON format and organizes the data for faster searching. The document is divided up into keys and values, and values can also comprise a deeper set of keys and values. These various keys and values are divided into the component parts and provide the way, or path, to navigate through the document. Much of MySQL’s JSON path expression work was heavily influenced by Facebook’s DocStore project.

The JSON document is made up of key/value pairs, arrays, and/or possibly combinations of the previous. These items that make up the document need ...

Get MySQL and JSON: A Practical Programming Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.