Book description
Table of contents
- Cover
- Title Page
- Copyright Page
- Dedication
- Contents
- Acknowledgments
- 1 Introduction
- 2 JSON as String Data vs. JSON as a Data Type
- 3 Finding the Path
- 4 Finding and Getting Data
-
5 Changing Data
- Using Arrays
- Appending Arrays
- Inserting into an Array
- Using TRUNCATE Before Adding New Data
- Using JSON_INSERT
- Using JSON_REPLACE
- JSON_REMOVE
- JSON_SET
- JSON_UNQUOTE
- The Three JSON_MERGE Functions
- JSON_MERGE
- JSON_MERGE_PRESERVE
- JSON_DEPTH
- JSON_LENGTH
- JSON_TYPE
- JSON_VALID
- JSON_STORAGE_SIZE
- JSON_STORAGE_FREE
- 6 JSON and Non-JSON Output
- 7 Generated Columns
- 8 GeoJSON
- 9 PHP’s JSON Functions
- 10 Loading JSON Data
- 11 The MySQL Document Store
- 12 Programming with the MySQL Document Store
- A Additional Resources
- Index
Product information
- Title: MySQL and JSON: A Practical Programming Guide
- Author(s):
- Release date: June 2018
- Publisher(s): McGraw-Hill
- ISBN: 9781260135459
You might also like
book
MySQL Crash Course
MySQL Crash Course is a fast-paced, no-nonsense introduction to relational database development. It’s filled with practical …
book
JavaScript and JSON Essentials
If you fancy a less verbose data format than CSV or XML, then JSON could be …
book
JavaScript JSON Cookbook
Over 80 recipes to make the most of JSON in your desktop, server, web, and mobile …
book
MySQL 8 Cookbook
Design and administer enterprise-grade MySQL 8 solutions About This Book Store, retrieve, and manipulate your data …