How do I insert a JS Object into a mysql row (in nodeJS)?

Question

Right now I use this cumbersome approach when I want to add a row whose data is in a JS Object

Adding a row to a table:

const mysql = require('mysql')
var db = mysql.createConnection(DBInfo)

var databaseObj = {val1: '1', name: 'John', age: 40} // row to insert

var query = 'INSERT INTO my_table ('
var databaseKeys = Object.keys(databaseObj)
for (let i = 0; i < databaseKeys.length; i++) {
  query += databaseKeys[i] + (i !== databaseKeys.length - 1 ? ', ' : ')')
}
query += ' ' + 'VALUES('
for (let i = 0; i < databaseKeys.length; i++) {
  query += '\'' + databaseObj[databaseKeys[i]] + '\'' + (i !== databaseKeys.length - 1 ? ', ' : ')')
}

db.query(query, function (err, results, fields) {...

Is there any simpler or neater way to add a row into a table, where such row data is in a JS Object? The examples I see around use an array of arrays, but in my case the info is in a Object

João Pimentel Ferreira · Accepted Answer · 2022-06-18 21:06:19Z

2

I should use the INSERT into table SET because they are equivalent

var db = mysql.createConnection(DBInfo)

var databaseObj = {val1: '1', name: 'John', age: 40}

var query = 'INSERT INTO my_table SET ' + db.escape(databaseObj)
db.query(query, function (err, results, fields) {...

edited Jun 18, 2022 at 21:06

answered Jun 15, 2021 at 21:44

João Pimentel Ferreira

16.5k13 gold badges98 silver badges131 bronze badges

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

Collectives™ on Stack Overflow

How do I insert a JS Object into a mysql row (in nodeJS)?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related