How to insert multiple rows with JSON data at the same time into MySQL using node.js?

Question

I want to insert multiple values into columns at the same time. For example, I have a JSON data with two rows of data, and I want to insert it at once in my table. I have tried this:

var data = ['{"sensorvalue":"96"},{"sensorvalue":"98"}']

const jsdata = JSON.parse(data);

connection.query("INSERT INTO `nodes`(`sensorvalue`) VALUES ('"+jsdata.sensorvalue+"')", (err, res) => {
    if(err) throw err;
    console.log("counter record inserted");  
});

Shows me this error:

{"sensorvalue":"96"},{"sensorvalue":"98"}
                    ^
SyntaxError: Unexpected token , in JSON

The output it should be:

id	sensorvalue
1	96
2	98

I would expect it to be var data = '[{"sensorvalue":"96"},{"sensorvalue":"98"}]' what you have is an array with a single element containing two objects with a comment in between. i have a string with a json array containing two objects — JoSSte
– JoSSte, Commented Jan 28, 2021 at 23:23
@Ali I think this is different not array of arrays instead it is a JSON data. — ismsm
– ismsm, Commented Jan 29, 2021 at 10:40

JoSSte · Accepted Answer · 2021-01-28 23:30:16Z

1

var data = ['{"sensorvalue":"96"},{"sensorvalue":"98"}']

should be

var data = '[{"sensorvalue":"96"},{"sensorvalue":"98"}]'

The top is an array with a single element containing two objects with a comma (,) in between. The bottom is a string with a json array containing two objects

answered Jan 28, 2021 at 23:30

JoSSte

3,4427 gold badges43 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ismsm Over a year ago

Thanks. But, I'm still I can not insert it as two rows.

Rick Il Grande · Accepted Answer · 2024-05-28 18:17:40Z

0

this should work:

var data = ["sensorvalue":"96",
            "sensorvalue":"98"]

answered May 28, 2024 at 18:17

Rick Il Grande

3312 silver badges4 bronze badges

Collectives™ on Stack Overflow

How to insert multiple rows with JSON data at the same time into MySQL using node.js?

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related