Database [connection과 pool-03] mysql.createPool 과 connection.query

const mysql = require('mysql2/promise');

(async function () {

    let pool = mysql.createPool({

        host: '127.0.0.1',

        user: 'root',

        password: '11111111',

        database: 'test',

        connectionLimit: 4

    }); 

 

// 커넥션 가져오기 

    let connection1 = await pool.getConnection(async conn => conn) 

    let connection2 = await pool.getConnection(async conn => conn) 

    let connection3 = await pool.getConnection(async conn => conn) 

    let connection4 = await pool.getConnection(async conn => conn) 

 

    let sql = 'SELECT *FROM users' 

    let user1 = await connection1.query(sql) 

    let user2 = await connection2.query(sql) 

    let user3 = await connection3.query(sql) 

    let user4 = await connection4.query(sql) 

 

    console.log(user1) 

    console.log(user2) 

    console.log(user3) 

    console.log(user4) 

 

})()