How to import JSON File to MySQL Table by using Workbench - MySQL DBA Tutorial

How to import JSON File to MySQL Table by using Workbench demo explains how to connect to MySQL Server by using MySQL Workbench and then import JSON file to MySQL table.

check out our other videos in the play list how to export data to JSON from MySQL Server table by using MySQL Workbench.

To follow step by step tutorial for MySQL DBA for beginner to Advance

MySQL Workbench Tutorial
MySQL DBA Certification Training
MySQL DBA Tutorial Step by Step
MySQL DBA Training online free
MySQL Real Time DBA Tutorial
MySQL Administration Course step by Step
MySQL Tools for Development and Admin

[cigrastudio_dev]

Thanks a lot, it was much easier than what I thought

[sherzodbekesanov]

Thank a lot !. You helped me so muchs. I wish you good luck .
From Uzbekistan 🇺🇿🇺🇿🇺🇿

[mattmunn]

THis is a good start, can you now explain how to load the JSON file into a table that keeps the data in its original JSON structure.

[mangola-xu]

It does not import data for some reason for me.

[shivanigangwar]

Hi
I am getting error as File not supporting when I am browsing the path of JSON file. How should I move forward

[mlizano]

I'm sorry, I don't understand your pronunciation ... but whatever, what happens if I have an identification column in the json file but yes in the table? the inserts will generate identifiers automatically? (auto increment)

[harshitagre]

This guy defeated chatgpt in 4 minutes
still

[prathimak]

Sir when I try to import json file in MySQL workbench it doesn't import properly it gives error : " Table data import: file type not supported, valid options CSV, JSON".what to fo