Difference between these two sql queries node js

Question

Is there a difference between using the query with [] and without? I'm supposed to choose the best one that does the same thing as this SELECT * FROM books WHERE name LIKE 'Pride and Prejudice'; but when I use both queries in node.js, they give the exact same output?

db.query("SELECT * FROM books WHERE name LIKE ?;",
"Pride and Prejudice",
(err, result) => { // the rest of the code...});

db.query("SELECT * FROM books WHERE name LIKE ?;",
["Pride and Prejudice"],
(err, result) => { // the rest of the code...});

When you only use a single replacement character ? then you don't have to use an array. Use one or the other, it's up to you, there's no difference. — Molda
– Molda, Commented Jan 3, 2021 at 10:28

Anatoly · Accepted Answer · 2021-01-03 10:29:45Z

1

I didn't find examples without passing an array to parameters, so I'd recommend always to use an array to pass parameters even if you have just one.

From the official documentation (the only one parameter also passed in an array):

const query = {
  // give the query a unique name
  name: 'fetch-user',
  text: 'SELECT * FROM user WHERE id = $1',
  values: [1],
}
// callback
client.query(query, (err, res) => {
  if (err) {
    console.log(err.stack)
  } else {
    console.log(res.rows[0])
  }
})

answered Jan 3, 2021 at 10:29

Anatoly

23.2k3 gold badges33 silver badges46 bronze badges

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

Collectives™ on Stack Overflow

Difference between these two sql queries node js

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related