连接

const mysql = require('mysql2');

// create the connection to database
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'root',
  database: 'verification_code'
});

增

connection.query(
  'INSERT INTO `foo` SET ?',
  {
    bar: 'bar',
    baz: 'baz'
  },
  (err, results, fields) => {
    if (err) {
      console.log(err)
      return
    }

    console.log(results)
  }
)

查

connection.query(
  'SELECT * FROM `foo` where `bar` = ?',
  bar,
  (err, results, fields) => {
    if (err) {
      console.log(err)
      return
    }

    console.log(results)
  }
)

connection.query(
  'SELECT * FROM `foo` where `bar` = ?, `baz` = ?',
  [bar, baz],
  (err, results, fields) => {
    if (err) {
      console.log(err)
      return
    }

    console.log(results)
  }
)