How to Insert into multiple columns from node express to MySQL db

Question

I'd like to insert these data name, title, body, timestamp, img_url to a new column in MySQL. How do I achieve that.

  static post(name) {
    return db.execute('INSERT INTO tablename (name) VALUES (?)', [name]);
  }

Does this answer your question? Insert multiple columns and rows into SQL Server with node js — Darth
– Darth, Commented Jan 20, 2021 at 14:38

Levon Babayan · Accepted Answer · 2021-01-20 15:51:10Z

1

const mysqlConnection = require('mysql');
const conn = mysql.createConnection({...});

var query = "INSERT INTO your_table (name, email, n) VALUES ?";
var values = [
    ['test1', '[email protected]', 1],
    ['test2', '[email protected]', 2],
];
conn.query(sql, [values], function(err) {
    if (err) throw err;
    conn.end();
});

answered Jan 20, 2021 at 15:51

Levon Babayan

2822 silver badges19 bronze badges

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

1 Comment

raj Over a year ago

Thank you. But it is very difficult to write a insert query like this. As I have more than 20 values (fields)..

Collectives™ on Stack Overflow

How to Insert into multiple columns from node express to MySQL db

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related