MySQL and JSON: A Practical Programming Guide

practical instruction on using javascript object notation (json) with mysql This hands-on guide teaches, step by step, how to use JavaScript Object Notation (JSON) with MySQL. Written by a MySQL Community Manager for Oracle, mysql and json: a practical programming guide shows how to quickly get started using JSON with MySQL and clearly explains the latest tools and functions. All content is based on the authors years of interaction with MySQL professionals. Throughout, real-world examples and sample code guide you through the syntax and application of each method. You will get in-depth coverage of programming with the MySQL Document Store. See how JavaScript Object Notation (JSON) works with MySQLUse JSON as string data and JSON as a data typeFind the path, load data, and handle searches with REGEXWork with JSON and non-JSON outputBuild virtual generated columns and stored generated columnsGenerate complex geometries using GeoJSONConvert and manage data with JSON functionsAccess JSON data, collections, and tables through MySQL Document Store