Episode-043 - Returning JSON Data as Relational Data in MySQL

Skip ad
9 Views

  • Thanks! Share it with your friends!

    You disliked this video. Thanks for the feedback!

mysql
Published
This video demonstrates how to use the JOSN path operator in MySQL to extract data from a JSON object and return those values in a standard query result as if the values were stored in a separate column.

JSON - Path Operator Documentation - https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#operator_json-inline-path

JSON_EXTRACT() Documentation - https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#function_json-extract

JSON_UNQUOTE() Documentation - https://dev.mysql.com/doc/refman/8.0/en/json-modification-functions.html#function_json-unquote
Category
MySQL
Tags
MySQL, Database, Open-source
Be the first to comment