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
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
- Category
- MySQL
- Tags
- MySQL, Database, Open-source
Be the first to comment



