How to store NDJSON file format log data in to mysql database(table) through shell script? [closed]
Clash Royale CLAN TAG#URR8PPP
up vote
-5
down vote
favorite
I have script which will do the curl requests and get the log data as NDJSON format data. For Example :-
"name":"Spider Man",
"age":"16",
"company":"ABCD"
"name":"Bat Man",
"age":"17",
"company":"EFGH"
I need to insert this data in to mysql database table. Name, Age, Company should be column header and Spider man, 16, ABCD will be rows. I need to achieve through shell script.
Additional explanation :-
Idea is to prepare a script which will run once in a day and read the log file (NDJSON format) and store in my sql database tables. From there will proceed further analysis from the stored data.
May be if you ask any part of my question is unclear, will try to explain more.
bash shell-script shell
asked Sep 28 at 8:13
Jhony
45
closed as unclear what you're asking by dr01, Jeff Schaller, Goro, RalfFriedl, jimmij Sep 28 at 19:41
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
 |Â
show 5 more comments
up vote
-5
down vote
favorite
I have script which will do the curl requests and get the log data as NDJSON format data. For Example :-
"name":"Spider Man",
"age":"16",
"company":"ABCD"
"name":"Bat Man",
"age":"17",
"company":"EFGH"
I need to insert this data in to mysql database table. Name, Age, Company should be column header and Spider man, 16, ABCD will be rows. I need to achieve through shell script.
Additional explanation :-
Idea is to prepare a script which will run once in a day and read the log file (NDJSON format) and store in my sql database tables. From there will proceed further analysis from the stored data.
May be if you ask any part of my question is unclear, will try to explain more.
bash shell-script shell
asked Sep 28 at 8:13
Jhony
45
closed as unclear what you're asking by dr01, Jeff Schaller, Goro, RalfFriedl, jimmij Sep 28 at 19:41
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
That was on hold. So created newly. Both are same.
– Jhony
Sep 28 at 8:51
1
Possible duplicate of How to store NDJSON file format data in to mysql database(table) through shell script?
– Anthony Geoghegan
Sep 28 at 8:56
4
When the original question was put on hold, the notice would have stated the reason why it was closed. The hold notice would also have suggested what you could do to improve the question. You should not copy the title and body into a new question! If a closed question is edited, it will automatically be nominated for re-opening. The goal for the asker is to sufficiently improve the quality so that moderators will vote to re-open the question. As you deleted the original question, I can’t see the close notice but I suspect it was closed because it was too broad.
– Anthony Geoghegan
Sep 28 at 10:08
3
Also, the downvotes are most likely because the question does not show any research effort. I’d advise taking the tour and reading How to Ask and other related help center documentation.
– Anthony Geoghegan
Sep 28 at 10:08
1
At the same time, us answerers are waiting for you to improve the question. Your move, sir.
– glenn jackman
Sep 28 at 13:53
 |Â
show 5 more comments
up vote
-5
down vote
favorite
up vote
-5
down vote
favorite
I have script which will do the curl requests and get the log data as NDJSON format data. For Example :-
"name":"Spider Man",
"age":"16",
"company":"ABCD"
"name":"Bat Man",
"age":"17",
"company":"EFGH"
I need to insert this data in to mysql database table. Name, Age, Company should be column header and Spider man, 16, ABCD will be rows. I need to achieve through shell script.
Additional explanation :-
Idea is to prepare a script which will run once in a day and read the log file (NDJSON format) and store in my sql database tables. From there will proceed further analysis from the stored data.
May be if you ask any part of my question is unclear, will try to explain more.
bash shell-script shell
asked Sep 28 at 8:13
Jhony
45
I have script which will do the curl requests and get the log data as NDJSON format data. For Example :-
"name":"Spider Man",
"age":"16",
"company":"ABCD"
"name":"Bat Man",
"age":"17",
"company":"EFGH"
I need to insert this data in to mysql database table. Name, Age, Company should be column header and Spider man, 16, ABCD will be rows. I need to achieve through shell script.
Additional explanation :-
Idea is to prepare a script which will run once in a day and read the log file (NDJSON format) and store in my sql database tables. From there will proceed further analysis from the stored data.
May be if you ask any part of my question is unclear, will try to explain more.
bash shell-script shell
bash shell-script shell
asked Sep 28 at 8:13
Jhony
45
asked Sep 28 at 8:13
Jhony
45
edited Oct 2 at 5:30
asked Sep 28 at 8:13
Jhony
45
asked Sep 28 at 8:13
Jhony
45
asked Sep 28 at 8:13
Jhony
45
45
closed as unclear what you're asking by dr01, Jeff Schaller, Goro, RalfFriedl, jimmij Sep 28 at 19:41
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
closed as unclear what you're asking by dr01, Jeff Schaller, Goro, RalfFriedl, jimmij Sep 28 at 19:41
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
That was on hold. So created newly. Both are same.
– Jhony
Sep 28 at 8:51
1
Possible duplicate of How to store NDJSON file format data in to mysql database(table) through shell script?
– Anthony Geoghegan
Sep 28 at 8:56
4
When the original question was put on hold, the notice would have stated the reason why it was closed. The hold notice would also have suggested what you could do to improve the question. You should not copy the title and body into a new question! If a closed question is edited, it will automatically be nominated for re-opening. The goal for the asker is to sufficiently improve the quality so that moderators will vote to re-open the question. As you deleted the original question, I can’t see the close notice but I suspect it was closed because it was too broad.
– Anthony Geoghegan
Sep 28 at 10:08
3
Also, the downvotes are most likely because the question does not show any research effort. I’d advise taking the tour and reading How to Ask and other related help center documentation.
– Anthony Geoghegan
Sep 28 at 10:08
1
At the same time, us answerers are waiting for you to improve the question. Your move, sir.
– glenn jackman
Sep 28 at 13:53
 |Â
show 5 more comments
That was on hold. So created newly. Both are same.
– Jhony
Sep 28 at 8:51
1
Possible duplicate of How to store NDJSON file format data in to mysql database(table) through shell script?
– Anthony Geoghegan
Sep 28 at 8:56
4
When the original question was put on hold, the notice would have stated the reason why it was closed. The hold notice would also have suggested what you could do to improve the question. You should not copy the title and body into a new question! If a closed question is edited, it will automatically be nominated for re-opening. The goal for the asker is to sufficiently improve the quality so that moderators will vote to re-open the question. As you deleted the original question, I can’t see the close notice but I suspect it was closed because it was too broad.
– Anthony Geoghegan
Sep 28 at 10:08
3
Also, the downvotes are most likely because the question does not show any research effort. I’d advise taking the tour and reading How to Ask and other related help center documentation.
– Anthony Geoghegan
Sep 28 at 10:08
1
At the same time, us answerers are waiting for you to improve the question. Your move, sir.
– glenn jackman
Sep 28 at 13:53
That was on hold. So created newly. Both are same.
– Jhony
Sep 28 at 8:51
That was on hold. So created newly. Both are same.
– Jhony
Sep 28 at 8:51
1
1
Possible duplicate of How to store NDJSON file format data in to mysql database(table) through shell script?
– Anthony Geoghegan
Sep 28 at 8:56
Possible duplicate of How to store NDJSON file format data in to mysql database(table) through shell script?
– Anthony Geoghegan
Sep 28 at 8:56
4
4
When the original question was put on hold, the notice would have stated the reason why it was closed. The hold notice would also have suggested what you could do to improve the question. You should not copy the title and body into a new question! If a closed question is edited, it will automatically be nominated for re-opening. The goal for the asker is to sufficiently improve the quality so that moderators will vote to re-open the question. As you deleted the original question, I can’t see the close notice but I suspect it was closed because it was too broad.
– Anthony Geoghegan
Sep 28 at 10:08
When the original question was put on hold, the notice would have stated the reason why it was closed. The hold notice would also have suggested what you could do to improve the question. You should not copy the title and body into a new question! If a closed question is edited, it will automatically be nominated for re-opening. The goal for the asker is to sufficiently improve the quality so that moderators will vote to re-open the question. As you deleted the original question, I can’t see the close notice but I suspect it was closed because it was too broad.
– Anthony Geoghegan
Sep 28 at 10:08
3
3
Also, the downvotes are most likely because the question does not show any research effort. I’d advise taking the tour and reading How to Ask and other related help center documentation.
– Anthony Geoghegan
Sep 28 at 10:08
Also, the downvotes are most likely because the question does not show any research effort. I’d advise taking the tour and reading How to Ask and other related help center documentation.
– Anthony Geoghegan
Sep 28 at 10:08
1
1
At the same time, us answerers are waiting for you to improve the question. Your move, sir.
– glenn jackman
Sep 28 at 13:53
At the same time, us answerers are waiting for you to improve the question. Your move, sir.
– glenn jackman
Sep 28 at 13:53
 |Â
show 5 more comments
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
That was on hold. So created newly. Both are same.
– Jhony
Sep 28 at 8:51
1
Possible duplicate of How to store NDJSON file format data in to mysql database(table) through shell script?
– Anthony Geoghegan
Sep 28 at 8:56
4
When the original question was put on hold, the notice would have stated the reason why it was closed. The hold notice would also have suggested what you could do to improve the question. You should not copy the title and body into a new question! If a closed question is edited, it will automatically be nominated for re-opening. The goal for the asker is to sufficiently improve the quality so that moderators will vote to re-open the question. As you deleted the original question, I can’t see the close notice but I suspect it was closed because it was too broad.
– Anthony Geoghegan
Sep 28 at 10:08
3
Also, the downvotes are most likely because the question does not show any research effort. I’d advise taking the tour and reading How to Ask and other related help center documentation.
– Anthony Geoghegan
Sep 28 at 10:08
1
At the same time, us answerers are waiting for you to improve the question. Your move, sir.
– glenn jackman
Sep 28 at 13:53