How to insert array in mySQL using node.js [duplicate]

Question

This code, using post as object, is working.

let post = {id: 1, name: 'Terminal 1'};
db.query('INSERT INTO terminal SET ?', post);

This code, using post as array, is not working.

let post = [
    {id: 1, name: 'Terminal 1'},
    {id: 2, name: 'Terminal 2'}
];
db.query('INSERT INTO terminal SET ?', post);
or 
db.query('INSERT INTO terminal SET ?', [post]);

Denys Levshenkov · Accepted Answer · 2021-09-02 16:13:51Z

1

You can call query for every object in array using for..of cycle:

let post = [
{id: 1, name: 'Terminal 1'},
{id: 2, name: 'Terminal 2'}
]
for (let object of post) {
db.query('INSERT INTO terminal SET ?', object)
}

answered Sep 2, 2021 at 16:13

Denys Levshenkov

2841 silver badge3 bronze badges

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

1 Comment

Rafael Segura Over a year ago

It is an option, but I'd preffer to solve it like a bulk insert to reduce request to the data base

Collectives™ on Stack Overflow

How to insert array in mySQL using node.js [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related