Stokes David. MySQL & JSON. A Practical Programming Guide

2nd edition. — David Stokes Publishing, 2020. — 180 p.JSON - JavaScript Object Notation - has become the data interchange format for most developers. MySQL added a JSON data type plus NoSQL JSON Document Store so developers can work with both relational tables and schema-less JSON document collections in version 5.7. MySQL 8.0 has introduced many new JSON centric features. This book is a practical guide on how to take advantage of JSON data with a MySQL database with numerous easy-to-follow examples, clear explanations, and coding examples.
This book will become your reference guide on using JSON data with a MySQL database, the numerous functions used with JSON data, the functions that can convert non-JSON relational data into JSON, the MySQL Document Store, and converting JSON data temporarily into structured (SQL) data for processing with SQL commands.JSON as String Data, JSON as a Data Type
Finding the Path
Finding and Getting Data
Changing Data
JSON and Non JSON OUTPUT
Generated Columns
GeoJSON
PHP’s JSON Functions
Loading JSON Data
The MySQL Document Store
Programming with the MySQL Document
Multi-Value Indexes
JSON Document Validation