0

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]);
Rafael Segura
  • 49
  • 7

1 Answers1

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)
}
Denys Levshenkov
  • 284
  • 1
  • 3