all AI news
How to tabulate a JSON document in MySQL
Oct. 9, 2023, 11 a.m. | Francesco Tisiot
DEV Community dev.to
You can tabulate a JSON document (retrieve it as a row) in MySQL with the JSON_TABLE
function.
NOTE: more info is available in the MySQL JSON functions documentation page
👉 Need a FREE MySQL database? check Aiven's free plans👈
The dataset
The dataset is the following:
{
"id": 778,
"shop": "Luigis Pizza",
"name": "Edward Olson",
"phoneNumbers":
["(935)503-3765x4154","(935)12345"],
"address": "Unit 9398 Box 2056 DPO AP 24022",
"image": null,
"pizzas": [
{
"pizzaName": "Salami",
"additionalToppings": ["🥓", "🌶️"]
},
{
"pizzaName": …
aiven check database dataset document documentation free function functions json mysql pizza
More from dev.to / DEV Community
Jobs in AI, ML, Big Data
AI Research Scientist
@ Vara | Berlin, Germany and Remote
Data Architect
@ University of Texas at Austin | Austin, TX
Data ETL Engineer
@ University of Texas at Austin | Austin, TX
Lead GNSS Data Scientist
@ Lurra Systems | Melbourne
Senior Machine Learning Engineer (MLOps)
@ Promaton | Remote, Europe
Senior Software Engineer, Generative AI (C++)
@ SoundHound Inc. | Toronto, Canada