Import .JSON files into MySQL

[Caio Cesar]

Good evening to everybody,

I have an university work where I must import some lots of .JSON data into MySQL.

Here's the thing:

I want to see if there is a possibility to do it using only stored procedures/triggers and resources from MySQL -- instead of converting the files into .csv or something like that.

A .JSON example is this one (the other ones have more information, about the athletes teams etc.):
*************************
{"id_competition":135,"event":"Gymnastics","year":2016,"season":"Summer","city":"Rio de Janeiro","sport":"Gymnastics"}
*************************
Basically, what I want to do is to use the .JSON files to insert in my tables (you can see the structure here: ).

I know that in Oracle, for example, you can make a function with selects using UTL_Files and JSON_Object to generate .JSON data from the tables; but is it possible to import the .JSON files into MySQL? (kinda doing the process backwards).

I really thank you all in advance and I apologize if I'm posting this in the wrong area.