Insert array as column in Node.js

Question

I want to insert each element from an array as the rows of a column.

Example:

array = [1,2,3,2];

the result will be:

column1 | 
---------
    1   |  
    2   |  
    3   |  
    2   |

I tried out the following code below in my Node.js file but it doesn't seem to work.

var array = [1,2,3,2]; 

var queryString = "INSERT INTO table (column1) VALUES ((${array.map((v,i) => `${i+1}`).join(',')}) RETURNING *";

    db.query(queryString, array, (err, result) => {
        if (err) throw err;
    });

Diego · Accepted Answer · 2021-01-25 08:10:40Z

1

I would rather use a package like sqlstring to ease the query creation and prevent nasty SQL injections. In any case the resulting SQL query should look like;

INSERT INTO table (column1) VALUES (1), (2), (3), (2);

const numbers = [1, 2, 3, 2];
const values = numbers.map (x => `(${x})`).join (', ');
const query = `INSERT INTO table (column1) VALUES ${values};`;

answered Jan 25, 2021 at 8:10

Diego

8167 silver badges17 bronze badges

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

1 Comment

ahmadalibin Over a year ago

How do I do the same for update? Do I need a forEach loop?

Collectives™ on Stack Overflow

Insert array as column in Node.js

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related