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

Question

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.

You should use a streaming JSON parser so you don't load the entire file into memory. See https://stackoverflow.com/questions/9390368/java-best-approach-to-parse-huge-extra-large-json-file — Bill Karwin, Mar 14 '22 at 00:25

score -1 · Answer 1 · answered Mar 14 '22 at 01:37

-1

you can use 'mysql workbench' or 'mysqljsonimport'

answered Mar 14 '22 at 01:37

dogs Cute

1 Answers1