MySQL and JSON by David Stokes

Author:David Stokes
Language: eng
Format: epub
Publisher: McGraw-Hill Education
Published: 2018-06-09T04:00:00+00:00

* * *

In this example, the desired data has the hasname column equal to 1 and the xHasValue column equal to 1. By using such queries, you can easily determine whether documents do indeed have certain key/value pairs.

* * *

Nested Data

JSON_TABLE also has the ability to walk down the JSON document path and retrieve nested data. In Example 6-11, there are several values of z for each record’s y key. The ability to extract each individual value comes from the NESTED PATH option.

Example 6-11 This name has nested values of key z within the key y.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.