node连接mysql，并进行增删查改

const mysql = require('mysql')
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'test'
})
connection.connect()

connection.query('SELECT * FROM `testTable`', function (error, results, fields) {
  if (error) throw error
  console.log(results)
})

// connection.query('INSERT INTO testTable (name) VALUES (?)', ['D'], function (error, results, fields) {
//   if (error) throw error
//     console.log(results)
// })

// connection.query('UPDATE testTable SET name=? WHERE id=?', ['DD', 4], function (error, results, fields) {
//   if (error) throw error
//     console.log(results)
// })

// connection.query('DELETE FROM testTable WHERE id=?', [4], function (error, results, fields) {
//   if (error) throw error
//     console.log(results)
// })
connection.end()