'How do I load the data into mysql where each line is a json?

I got a dataset where each line is in json format.

{"name":"alpha", "id":"111"}\n
{"name":"beta", "id":"222"}\n
...

But how do I load it into a mysql database? The dataset is quite large and it is impossible to parse it line by line in java.

java mysql json

Solution 1:^[1]

you can use 'mysql workbench' or 'mysqljsonimport'

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1	dogs Cute