Breaking News: Grepper is joining You.com. Read the official announcement!

nodejs mysql query

Jerome Scott answered on May 1, 2022 Popularity 10/10 Helpfulness 3/10

answer nodejs mysql query

related mysql query node.js

nodejs mysql query

Comment

//The second form .query(sqlString, values, callback) comes when using placeholder values 
connection.query('SELECT * FROM `books` WHERE `author` = ?', ['David'], function (error, results, fields) {
  // error will be an Error if one occurred during the query
  // results will contain the results of the query
  // fields will contain information about the returned results fields (if any)
});

//The third form .query(options, callback) comes when using various advanced options on the query
connection.query({
  sql: 'SELECT * FROM `books` WHERE `author` = ?',
  timeout: 40000, // 40s
  values: ['David']
}, function (error, results, fields) {
  // error will be an Error if one occurred during the query
  // results will contain the results of the query
  // fields will contain information about the returned results fields (if any)
});

Popularity 10/10 Helpfulness 3/10 Language javascript

Source: www.npmjs.com

Tags: javascript mysql

Link to this answer
Share Copy Link

Contributed on May 01 2022

Jerome Scott

0 Answers Avg Quality 2/10

Closely Related Answers

mysql query node.js

Comment

const mysql=require('mysql2')

const connection = mysql.createPool({
    host: 'localhost',
    user:'root',
    password:'whatever it is',
    database: "whatever it is"
})

const sqlInsert = 'INSERT INTO reviews (fieldName1, fieldName2) values (?, ?)' // whatever query you want
connection.query(
  sqlInsert,
  [value1, value2], // inserts into '?' symbol
  (err, results, fields) => {
    if(err){
      console.log(err)
    }
    else{
      console.log(results)
    }
  }
)

Popularity 10/10 Helpfulness 5/10 Language javascript

Source: Grepper

Tags: javascript j

Link to this answer
Share Copy Link

Contributed on Aug 03 2022

yoda with shotgun (not real)

0 Answers Avg Quality 2/10

nodejs mysql query

Contents

More Related Answers

nodejs mysql query

Closely Related Answers

mysql query node.js

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.