Episode-017 – Using MySQL Document Store: Native SQL

In this video, we discuss how to use native JSON functionality to access data in a Document Store collection with native SQL.

MySQL Document Store Documentation: https://www.mysql.com/products/enterprise/document_store.html

MySQL Shell: https://dev.mysql.com/doc/mysql-shell/8.0/en/
JSON_EXTRACT() – https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html#function_json-extract

JSON_UNQUOTE() – https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html#function_json-unquote

JSON_TABLE() – https://dev.mysql.com/doc/refman/8.0/en/json-table-functions.html#function_json-table