J
J
jekanok2020-02-06 09:28:21
MySQL
jekanok, 2020-02-06 09:28:21

How to save multi-row query in mysql via node.js?

My question is how to save multi row query in mysql via node.js?

for (let key in results) {
        pool.query(
          `INSERT INTO users (username, firstname, lastname, age) VALUES ("${results[key].username}","${results[key].firstname}","${results[key].lastname}","${results[key].age}" )`,
          function(err, rows, fields) {}
        );
      }

how will the query be executed correctly?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question