MySQL Shorts is a playlist on the MySQL YouTube channel dedicated to short form tutorials that focus on a single feature or solution to a problem.
This video series covers a variety of different topics. For this post, we will sumamrize all the ‘Shorts’ that highlight ways to work with JSON.
Episode 9
For Episode 9, we discuss how you can import JSON data into a MySQL column that uses the JSON data type.
Episode 39
In this episode, we demonstrate how to write queries to write and retrieve JSON data.
Episode 40
There are several ways to update JSON values. Episode 40 shows off some of them.
Episode 41
If you have a property in a JOSN blob you want to remove, head on over to Episode 41 to learn how.
Episode 42
Do you have relational data that you want to return as JSON? Check out Episode 42!
Episode 43
If you want to return JSON data as relational data, Episode 43 has you covered.
Episode 44
Acsessing JSON array data is made easier with json_table(). We discuss the syntax in Episode 44.
Episode 51
Episode 51 shows how to validate a JSON schema when inserting it into the database.