Node.jsでMySQLにアクセスする

npm install mysql2

const mysql = require('mysql2');

npm install mysql

const mysql = require('mysql');

"use strict";
const mysql = require('mysql2');
// pool を Promise にするために必要.
const util = require('util');

/* 接続情報. */
const mySqlPoolOptions = {
    host: 'localhost',
    user: 'node-user',
    password: '00000000',
    database: 'node_sample_db',
};

async function insertUserAsync(id, name) {
  const pool = mysql.createPool(mySqlPoolOptions);
  pool.query = util.promisify(pool.query);
  try {
    const res = await pool.query('INSERT INTO users (id, name) VALUES (?, ?)', [id, name]);
    return res.affectedRows == 1;
  } catch (err) {
    console.log(err);
    return false;
  } finally {
    pool.end();
  }
}

async function selectUsersAsync() {
  const pool = mysql.createPool(mySqlPoolOptions);
  pool.query = util.promisify(pool.query);
  try {
    const rows = await pool.query('SELECT * FROM users');
    for (let row of rows) {
      console.log(${row.id} : ${row.name});
    }
  } catch (err) {
    console.log(err);
  } finally {
    pool.end();
  }
}

insertUserAsync('U0003', 'user 003').then(result => {
  console.log(result);
  return selectUsersAsync();
}).then(() => {
  console.log("finish");
});

true
U0001 : user 001
U0002 : user 002
U0003 : user 003
finish