{"id":2370,"date":"2026-09-05T19:28:30","date_gmt":"2026-09-05T19:28:30","guid":{"rendered":"https:\/\/wayhope.kro.kr\/?p=2370"},"modified":"2026-09-05T19:28:30","modified_gmt":"2026-09-05T19:28:30","slug":"node-js-mysql-connection-pool%ea%b3%bc-transaction-%ec%b2%98%eb%a6%ac-%ea%b5%ac%ec%a1%b0","status":"publish","type":"post","link":"https:\/\/wayhope.kro.kr\/?p=2370","title":{"rendered":"Node.js MySQL Connection Pool\uacfc Transaction \ucc98\ub9ac \uad6c\uc870"},"content":{"rendered":"\n

\uc628\ub77c\uc778 \uac8c\uc784 \uc11c\ubc84\uc5d0\uc11c DB\ub97c \ub2e4\ub8f0 \ub54c \ub2e8\uc21c\ud788 SQL\uc744 \uc2e4\ud589\ud558\ub294 \uac83\ub9cc\uc73c\ub85c \ub05d\ub098\ub294 \uacbd\uc6b0\ub294 \uc0dd\uac01\ubcf4\ub2e4 \ub9ce\uc9c0 \uc54a\ub2e4.<\/p>\n\n\n\n

\ud50c\ub808\uc774\uc5b4\uc758 \uc7ac\ud654\ub97c \ucc28\uac10\ud558\uace0 \uc544\uc774\ud15c\uc744 \uc9c0\uae09\ud558\uac70\ub098, \uc6b0\ud3b8\uc744 \uc0ad\uc81c\ud558\uba74\uc11c \ubcf4\uc0c1\uc744 \uc9c0\uae09\ud558\ub294 \uac83\ucc98\ub7fc \ud558\ub098\uc758 \uac8c\uc784 \ub85c\uc9c1\uc774 \uc5ec\ub7ec \uac1c\uc758 SQL\ub85c \uad6c\uc131\ub418\ub294 \uacbd\uc6b0\uac00 \ub9ce\ub2e4.<\/p>\n\n\n\n

\uc774\ub7f0 \uc791\uc5c5\uc5d0\uc11c \uc911\uc694\ud55c \uac83\uc740 \uac01\uac01\uc758 SQL\uc774 \uc815\uc0c1\uc801\uc73c\ub85c \uc2e4\ud589\ub418\ub294 \uac83\uc774 \uc544\ub2c8\ub77c \ud558\ub098\uc758 \uc791\uc5c5 \ub2e8\uc704\ub85c \ubaa8\ub450 \uc131\uacf5\ud558\uac70\ub098 \ubaa8\ub450 \uc2e4\ud328\ud574\uc57c \ud55c\ub2e4\ub294 \uac83<\/strong>\uc774\ub2e4.<\/p>\n\n\n\n

\uadf8\ub798\uc11c DB \uc811\uadfc \ucf54\ub4dc\ub97c \ucc98\uc74c \uad6c\uc131\ud560 \ub54c\ubd80\ud130 \uc77c\ubc18 \ucffc\ub9ac\uc640 \ud2b8\ub79c\uc7ad\uc158 \ucffc\ub9ac\ub97c \ubd84\ub9ac\ud588\ub2e4.<\/p>\n\n\n\n

\uc804\uccb4\uc801\uc778 \uad6c\uc870\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n

MySQL Connection Pool\n-> \uc77c\ubc18 Query \/ Transaction Query\n-> Connection \ud68d\ub4dd\n-> SQL \uc2e4\ud589\n-> Connection \ubc18\ud658\n<\/code><\/pre>\n\n\n\n
\ud2b8\ub79c\uc7ad\uc158\uc740 \uc5ec\uae30\uc5d0 Commit\uacfc Rollback\uc774 \ucd94\uac00\ub41c\ub2e4.<\/p>\n\n\n\n
Connection \ud68d\ub4dd\n-> Begin Transaction\n-> Query 1\n-> Query 2\n-> Query 3\n-> Commit\n-> Connection \ubc18\ud658\n<\/code><\/pre>\n\n\n\n
\uc911\uac04\uc5d0 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \ucc98\ub9ac\ud55c\ub2e4.<\/p>\n\n\n\n
Connection \ud68d\ub4dd\n-> Begin Transaction\n-> Query 1\n-> Query 2 \uc2e4\ud328\n-> Rollback\n-> Connection \ubc18\ud658\n<\/code><\/pre>\n\n\n\n
Connection Pool\uc744 \uc0ac\uc6a9\ud558\ub294 \uc774\uc720<\/h2>\n\n\n\n
DB Connection\uc744 \uc694\uccad\ud560 \ub54c\ub9c8\ub2e4 \uc0c8\ub85c \uc0dd\uc131\ud558\ub294 \ubc29\uc2dd\uc740 \uc11c\ubc84 \uad6c\uc870\uc5d0\uc11c \ud6a8\uc728\uc801\uc774\uc9c0 \uc54a\ub2e4.<\/p>\n\n\n\n
\uc628\ub77c\uc778 \uac8c\uc784 \uc11c\ubc84\uc5d0\uc11c\ub294 \ub3d9\uc2dc\uc5d0 \uc5ec\ub7ec \uc694\uccad\uc774 \ub4e4\uc5b4\uc62c \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0 Connection\uc744 \ubbf8\ub9ac Pool \ud615\ud0dc\ub85c \uad00\ub9ac\ud558\uace0 \ud544\uc694\ud560 \ub54c \ud558\ub098\ub97c \uac00\uc838\uc624\ub294 \ubc29\uc2dd\uc744 \uc0ac\uc6a9\ud588\ub2e4.<\/p>\n\n\n\n
import * as mysql from \"mysql\";\nimport { ErrorLog, Log } from \"..\/..\/util-module\/time-log-module\/time-log\";\nimport * as config from \"..\/..\/..\/config\/mysql-config\";\n\nlet mysqlConnectionPool: mysql.Pool;\n\nexport function GenerateMysqlConnectPool() {\n    try {\n        mysqlConnectionPool = mysql.createPool(\n            config.DBConnectConfig\n        );\n\n        Log(__filename, \"success created db pool\");\n    }\n    catch (err: NodeJS.ErrnoException | any) {\n        ErrorLog(__filename, err.message);\n    }\n}\n<\/code><\/pre>\n\n\n\n
\uc11c\ubc84 \uc2dc\uc791 \uacfc\uc815\uc5d0\uc11c Pool\uc744 \uc0dd\uc131\ud574\ub450\uace0 \uc2e4\uc81c DB \uc791\uc5c5\uc774 \ud544\uc694\ud560 \ub54c Connection\uc744 \ud558\ub098 \uac00\uc838\uc628\ub2e4.<\/p>\n\n\n\n
mysqlConnectionPool.getConnection((err, conn) => {\n    \/\/ DB \uc791\uc5c5\n});\n<\/code><\/pre>\n\n\n\n
\uc791\uc5c5\uc774 \ub05d\ub098\uba74 release()<\/code>\ub97c \ud638\ucd9c\ud55c\ub2e4.<\/p>\n\n\n\n
conn.release();\n<\/code><\/pre>\n\n\n\n
\uc5ec\uae30\uc11c release()<\/code>\ub294 Connection\uc744 \uc885\ub8cc\ud558\ub294 \uac83\uc774 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n
\ud604\uc7ac \uc0ac\uc6a9\ud55c Connection\uc744 Pool\uc5d0 \ubc18\ud658\ud558\ub294 \uac83\uc774\ub2e4.<\/p>\n\n\n\n
\ub530\ub77c\uc11c \ub2e4\uc74c \uc694\uccad\uc5d0\uc11c\ub294 Pool\uc5d0 \ubc18\ud658\ub418\uc5b4 \uc788\ub294 Connection\uc744 \ub2e4\uc2dc \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n
\uc77c\ubc18 Query \ucc98\ub9ac<\/h2>\n\n\n\n
\ub2e8\uc77c SQL\uc744 \uc2e4\ud589\ud558\ub294 \uacbd\uc6b0\uc5d0\ub294 \ubcc4\ub3c4\uc758 \ud2b8\ub79c\uc7ad\uc158\uc744 \ub9cc\ub4e4 \ud544\uc694\uac00 \uc5c6\ub2e4.<\/p>\n\n\n\n
\uadf8\ub798\uc11c \uc77c\ubc18\uc801\uc778 DB \uc811\uadfc\uc740 \ubcc4\ub3c4\uc758 \ud568\uc218\ub85c \ubd84\ub9ac\ud588\ub2e4.<\/p>\n\n\n\n
export function Query(\n    query: string,\n    options: any\n): Promise<any> {\n    return new Promise<any>((resolve, reject) => {\n\n        mysqlConnectionPool.getConnection((err, conn) => {\n\n            if (err) {\n                ErrorLog(__filename, err.message);\n                return reject(err);\n            }\n\n            conn.query(\n                query,\n                options,\n                (err: mysql.MysqlError | null, results: any) => {\n\n                    conn.release();\n\n                    if (err) {\n                        ErrorLog(__filename, err.message);\n                        return reject(err);\n                    }\n\n                    resolve(results);\n                }\n            );\n        });\n    });\n}\n<\/code><\/pre>\n\n\n\n
\uc0ac\uc6a9\ud558\ub294 \ucabd\uc5d0\uc11c\ub294 async \/ await<\/code>\ub85c \ucc98\ub9ac\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n
const result = await Query(\n    `\n        SELECT *\n        FROM player_tb\n        WHERE player_code = ?\n    `,\n    [playerCode]\n);\n<\/code><\/pre>\n\n\n\n
DB \ub77c\uc774\ube0c\ub7ec\ub9ac \uc790\uccb4\ub294 Callback \uae30\ubc18\uc774\uc9c0\ub9cc Promise\ub85c \uac10\uc2f8\ub450\uc5c8\uae30 \ub54c\ubb38\uc5d0 \uc11c\ubc84\uc758 \ub2e4\ub978 \ub85c\uc9c1\uc5d0\uc11c\ub294 \ube44\ub3d9\uae30 \ud750\ub984\uc744 \uc77c\uad00\ub418\uac8c \uc720\uc9c0\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n
\uc65c Transaction\uc774 \ud544\uc694\ud55c\uac00<\/h2>\n\n\n\n
\ubb38\uc81c\ub294 \ud558\ub098\uc758 \uac8c\uc784 \uae30\ub2a5\uc774 \uc5ec\ub7ec SQL\uc744 \ud544\uc694\ub85c \ud560 \ub54c \ubc1c\uc0dd\ud55c\ub2e4.<\/p>\n\n\n\n
\uc608\ub97c \ub4e4\uc5b4 \uc544\uc774\ud15c \uad6c\ub9e4\ub97c \uc0dd\uac01\ud574\ubcf4\uba74 \ub41c\ub2e4.<\/p>\n\n\n\n
\ud50c\ub808\uc774\uc5b4 \uace8\ub4dc \ucc28\uac10\n+\n\uc778\ubca4\ud1a0\ub9ac \uc544\uc774\ud15c \uc9c0\uae09\n<\/code><\/pre>\n\n\n\n
SQL\ub85c \ubcf4\uba74 \uac01\uac01 \ubcc4\ub3c4\uc758 \uc791\uc5c5\uc774\ub2e4.<\/p>\n\n\n\n
UPDATE player_tb\nSET gold = gold - ?\nWHERE player_code = ?;\n<\/code><\/pre>\n\n\n\n
INSERT INTO inventory_tb\n(\n    player_code,\n    item_code,\n    amount\n)\nVALUES (?, ?, ?);\n<\/code><\/pre>\n\n\n\n
\uc815\uc0c1\uc801\uc778 \uc0c1\ud669\uc5d0\uc11c\ub294 \ubb38\uc81c\uac00 \uc5c6\ub2e4.<\/p>\n\n\n\n
\ud558\uc9c0\ub9cc \uccab \ubc88\uc9f8 SQL\uc774 \uc131\uacf5\ud558\uace0 \ub450 \ubc88\uc9f8 SQL\uc774 \uc2e4\ud328\ud55c\ub2e4\uba74 \ubb38\uc81c\uac00 \uc0dd\uae34\ub2e4.<\/p>\n\n\n\n
\uace8\ub4dc \ucc28\uac10 \uc131\uacf5\n-> \uc544\uc774\ud15c \uc9c0\uae09 \uc2e4\ud328\n<\/code><\/pre>\n\n\n\n
\uacb0\uacfc\uc801\uc73c\ub85c \ud50c\ub808\uc774\uc5b4\uc758 \uace8\ub4dc\ub294 \uac10\uc18c\ud588\ub294\ub370 \uc544\uc774\ud15c\uc740 \uc9c0\uae09\ub418\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n\n\n\n
\uc774\ub7f0 \ub370\uc774\ud130 \ubd88\uc77c\uce58\ub97c \ub9c9\uae30 \uc704\ud574 \ub450 SQL\uc744 \ud558\ub098\uc758 Transaction\uc73c\ub85c \ubb36\ub294\ub2e4.<\/p>\n\n\n\n
Transaction Start\n-> \uace8\ub4dc \ucc28\uac10\n-> \uc544\uc774\ud15c \uc9c0\uae09\n-> Commit\n<\/code><\/pre>\n\n\n\n
\uc911\uac04\uc5d0 \ud558\ub098\ub77c\ub3c4 \uc2e4\ud328\ud558\uba74 \uc804\uccb4\ub97c \ucde8\uc18c\ud55c\ub2e4.<\/p>\n\n\n\n
Transaction Start\n-> \uace8\ub4dc \ucc28\uac10\n-> \uc544\uc774\ud15c \uc9c0\uae09 \uc2e4\ud328\n-> Rollback\n<\/code><\/pre>\n\n\n\n
TransactionQuery \uad6c\ud604<\/h2>\n\n\n\n
\uae30\uc874 \uc77c\ubc18 Query\uc640 \ubcc4\ub3c4\ub85c \uc5ec\ub7ec SQL\uc744 \ud558\ub098\uc758 Transaction\uc73c\ub85c \ucc98\ub9ac\ud558\ub294 \ud568\uc218\ub97c \uad6c\uc131\ud588\ub2e4.<\/p>\n\n\n\n
export function TransactionQuery(\n    queries: {\n        sql: string;\n        options: any;\n    }[]\n): Promise<any[]> {\n\n    return new Promise<any[]>((resolve, reject) => {\n\n        mysqlConnectionPool.getConnection((err, conn) => {\n\n            if (err) {\n                ErrorLog(__filename, err.message);\n                return reject(err);\n            }\n\n            conn.beginTransaction((err) => {\n\n                if (err) {\n                    conn.release();\n                    return reject(err);\n                }\n\n                executeQueries();\n\n                async function executeQueries() {\n\n                    try {\n\n                        const results: any[] = [];\n\n                        for (const query of queries) {\n\n                            const result = await new Promise<any>(\n                                (resolveQuery, rejectQuery) => {\n\n                                    conn.query(\n                                        query.sql,\n                                        query.options,\n                                        (\n                                            queryErr,\n                                            queryResult\n                                        ) => {\n\n                                            if (queryErr) {\n                                                return rejectQuery(queryErr);\n                                            }\n\n                                            resolveQuery(queryResult);\n                                        }\n                                    );\n                                }\n                            );\n\n                            results.push(result);\n                        }\n\n                        conn.commit((commitErr) => {\n\n                            if (commitErr) {\n\n                                conn.rollback(() => {\n                                    conn.release();\n                                    reject(commitErr);\n                                });\n\n                                return;\n                            }\n\n                            conn.release();\n                            resolve(results);\n                        });\n\n                    }\n                    catch (executeErr: any) {\n\n                        conn.rollback(() => {\n\n                            ErrorLog(\n                                __filename,\n                                `Transaction Failed: ${executeErr.message}`\n                            );\n\n                            conn.release();\n                            reject(executeErr);\n                        });\n                    }\n                }\n            });\n        });\n    });\n}\n<\/code><\/pre>\n\n\n\n
\ud575\uc2ec\uc740 SQL \ubc30\uc5f4\uc744 \uc804\ub2ec\ubc1b\uace0 \ub3d9\uc77c\ud55c Connection\uc5d0\uc11c \uc21c\uc11c\ub300\ub85c \uc2e4\ud589\ud55c\ub2e4\ub294 \uac83<\/strong>\uc774\ub2e4.<\/p>\n\n\n\n
\uc608\ub97c \ub4e4\uc5b4 \uc544\uc774\ud15c \uad6c\ub9e4\ub77c\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n
await TransactionQuery([\n    {\n        sql: `\n            UPDATE player_tb\n            SET gold = gold - ?\n            WHERE player_code = ?\n        `,\n        options: [price, playerCode]\n    },\n\n    {\n        sql: `\n            INSERT INTO inventory_tb\n            (\n                player_code,\n                item_code,\n                amount\n            )\n            VALUES (?, ?, ?)\n        `,\n        options: [\n            playerCode,\n            itemCode,\n            amount\n        ]\n    }\n]);\n<\/code><\/pre>\n\n\n\n
\uc11c\ubc84\uc5d0\uc11c\ub294 \uc774\uac83\uc744 \ud558\ub098\uc758 DB \uc791\uc5c5\uc73c\ub85c \ucde8\uae09\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n
Transaction\uc5d0\uc11c \uac19\uc740 Connection\uc744 \uc0ac\uc6a9\ud558\ub294 \uc774\uc720<\/h2>\n\n\n\n
\uc774 \ubd80\ubd84\uc740 \uad6c\ud604\ud560 \ub54c \ud2b9\ud788 \uc911\uc694\ud558\ub2e4.<\/p>\n\n\n\n
Transaction\uc740 Connection\uc5d0 \uc885\uc18d\ub41c\ub2e4.<\/p>\n\n\n\n
\ub530\ub77c\uc11c \ub2e4\uc74c\uacfc \uac19\uc740 \uad6c\uc870\uac00 \ub418\uc5b4\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n
Pool\n-> Connection A \ud68d\ub4dd\n-> Begin Transaction\n-> Query 1\n-> Query 2\n-> Query 3\n-> Commit\n-> Connection A \ubc18\ud658\n<\/code><\/pre>\n\n\n\n
\uac01 Query\ub9c8\ub2e4 \uc0c8\ub85c\uc6b4 Connection\uc744 \uac00\uc838\uc624\uba74 \uc548 \ub41c\ub2e4.<\/p>\n\n\n\n
\uc608\ub97c \ub4e4\uc5b4 \ub2e4\uc74c\uacfc \uac19\uc740 \ubc29\uc2dd\uc740 Transaction\uc774\ub77c\ub294 \ubaa9\uc801\uc744 \ub2ec\uc131\ud560 \uc218 \uc5c6\ub2e4.<\/p>\n\n\n\n
Query 1 -> Connection A\nQuery 2 -> Connection B\nQuery 3 -> Connection C\n<\/code><\/pre>\n\n\n\n
\ubc18\ub4dc\uc2dc \ud558\ub098\uc758 Connection\uc744 \uc7a1\uc544\ub193\uace0 \uadf8 Connection\uc5d0\uc11c Transaction\uc5d0 \ud3ec\ud568\ub41c \ubaa8\ub4e0 SQL\uc744 \uc2e4\ud589\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n
\uadf8\ub798\uc11c \uc77c\ubc18 Query()<\/code>\uc640 TransactionQuery()<\/code>\uc758 \uad6c\uc870\uac00 \uc870\uae08 \ub2e4\ub974\ub2e4.<\/p>\n\n\n\n
\uc77c\ubc18 Query\ub294 \ud558\ub098\uc758 SQL\uc744 \ucc98\ub9ac\ud558\uace0 \ubc14\ub85c Connection\uc744 \ubc18\ud658\ud55c\ub2e4.<\/p>\n\n\n\n
Connection \ud68d\ub4dd\n-> Query\n-> Connection \ubc18\ud658\n<\/code><\/pre>\n\n\n\n
Transaction\uc740 \uc5ec\ub7ec SQL\uc744 \ucc98\ub9ac\ud55c \ud6c4 Commit \ub610\ub294 Rollback\uae4c\uc9c0 \ub05d\ub0b4\uace0 \ubc18\ud658\ud55c\ub2e4.<\/p>\n\n\n\n
Connection \ud68d\ub4dd\n-> Begin\n-> Query\n-> Query\n-> Query\n-> Commit \/ Rollback\n-> Connection \ubc18\ud658\n<\/code><\/pre>\n\n\n\n
Query\ub97c \uc21c\ucc28\uc801\uc73c\ub85c \uc2e4\ud589\ud558\ub294 \uc774\uc720<\/h2>\n\n\n\n
TransactionQuery\uc5d0\uc11c\ub294 for ... of<\/code>\uc640 await<\/code>\ub97c \uc0ac\uc6a9\ud588\ub2e4.<\/p>\n\n\n\n
for (const query of queries) {\n\n    const result = await new Promise<any>(\n        (resolveQuery, rejectQuery) => {\n\n            conn.query(\n                query.sql,\n                query.options,\n                (queryErr, queryResult) => {\n\n                    if (queryErr) {\n                        return rejectQuery(queryErr);\n                    }\n\n                    resolveQuery(queryResult);\n                }\n            );\n        }\n    );\n\n    results.push(result);\n}\n<\/code><\/pre>\n\n\n\n
\uc774\ub807\uac8c \ud558\uba74 \uc804\ub2ec\ub41c SQL \uc21c\uc11c\ub97c \uadf8\ub300\ub85c \uc720\uc9c0\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n
\uc608\ub97c \ub4e4\uc5b4 \ub2e4\uc74c\uacfc \uac19\uc740 \uc791\uc5c5\uc774 \uc788\ub2e4\uace0 \ud558\uc790.<\/p>\n\n\n\n
\uc7ac\ud654 \ucc28\uac10\n-> \uc544\uc774\ud15c \uc9c0\uae09\n-> \ud018\uc2a4\ud2b8 \uc9c4\ud589\ub3c4 \uac31\uc2e0\n<\/code><\/pre>\n\n\n\n
\uccab \ubc88\uc9f8 \ucffc\ub9ac\uac00 \ub05d\ub09c \ub2e4\uc74c \ub450 \ubc88\uc9f8 \ucffc\ub9ac\ub97c \uc2e4\ud589\ud558\uace0, \ub450 \ubc88\uc9f8\uac00 \ub05d\ub09c \ub2e4\uc74c \uc138 \ubc88\uc9f8\ub97c \uc2e4\ud589\ud55c\ub2e4.<\/p>\n\n\n\n
\uadf8\ub9ac\uace0 \ub9c8\uc9c0\ub9c9 \ucffc\ub9ac\uae4c\uc9c0 \uc131\uacf5\ud55c \ub4a4\uc5d0\uc57c Commit\ud55c\ub2e4.<\/p>\n\n\n\n
\uc911\uac04\uc5d0 \ud558\ub098\ub77c\ub3c4 \uc2e4\ud328\ud558\uba74 Promise\uac00 Reject\ub418\uace0 catch<\/code>\ub85c \ub118\uc5b4\uac04\ub2e4.<\/p>\n\n\n\n
Rollback \ucc98\ub9ac<\/h2>\n\n\n\n
\uc2e4\ud589 \uacfc\uc815\uc5d0\uc11c \uc624\ub958\uac00 \ubc1c\uc0dd\ud558\uba74 \ub2e4\uc74c \ucf54\ub4dc\uac00 \uc2e4\ud589\ub41c\ub2e4.<\/p>\n\n\n\n
catch (executeErr: any) {\n\n    conn.rollback(() => {\n\n        ErrorLog(\n            __filename,\n            `Transaction Failed: ${executeErr.message}`\n        );\n\n        conn.release();\n        reject(executeErr);\n    });\n}\n<\/code><\/pre>\n\n\n\n
Rollback \uc774\ud6c4\uc5d0\ub294 Connection\uc744 \ubc18\ub4dc\uc2dc Pool\uc5d0 \ubc18\ud658\ud55c\ub2e4.<\/p>\n\n\n\n
conn.release();\n<\/code><\/pre>\n\n\n\n
\uc774 \ubd80\ubd84\uc744 \ube60\ub728\ub9ac\uba74 Connection\uc774 Pool\ub85c \ub3cc\uc544\uac00\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc5d0 \uc7a5\uc2dc\uac04 \uc11c\ubc84\ub97c \uc6b4\uc601\ud588\uc744 \ub54c Connection \ubd80\uc871 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n
\ub530\ub77c\uc11c Transaction \ucc98\ub9ac\uc5d0\uc11c \uc911\uc694\ud55c \uac83\uc740 \ub2e8\uc21c\ud788 rollback()<\/code>\uc744 \ud638\ucd9c\ud558\ub294 \uac83\uc774 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n
\uc131\uacf5\ud558\ub4e0 \uc2e4\ud328\ud558\ub4e0 Connection\uc758 \uc0dd\uba85\uc8fc\uae30\ub97c \uc815\uc0c1\uc801\uc73c\ub85c \ub05d\ub0b4\uc57c \ud55c\ub2e4.<\/strong><\/p>\n\n\n\n
Commit \uc2e4\ud328\ub3c4 \ucc98\ub9ac\ud574\uc57c \ud55c\ub2e4<\/h2>\n\n\n\n
\ubaa8\ub4e0 Query\uac00 \uc131\uacf5\ud588\ub2e4\uace0 \ud574\uc11c \ubb34\uc870\uac74 DB \uc791\uc5c5\uc774 \ub05d\ub09c \uac83\uc740 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n
\ub9c8\uc9c0\ub9c9\uc5d0\ub294 Commit\uc744 \uc218\ud589\ud55c\ub2e4.<\/p>\n\n\n\n
conn.commit((commitErr) => {\n\n    if (commitErr) {\n\n        conn.rollback(() => {\n            conn.release();\n            reject(commitErr);\n        });\n\n        return;\n    }\n\n    conn.release();\n    resolve(results);\n});\n<\/code><\/pre>\n\n\n\n
Commit \uacfc\uc815\uc5d0\uc11c\ub3c4 \uc624\ub958\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0 \ubcc4\ub3c4\ub85c \ucc98\ub9ac\ud588\ub2e4.<\/p>\n\n\n\n
\uc815\uc0c1\uc801\uc778 \uacbd\uc6b0\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n
Query 1 \uc131\uacf5\n-> Query 2 \uc131\uacf5\n-> Query 3 \uc131\uacf5\n-> Commit \uc131\uacf5\n-> Connection \ubc18\ud658\n<\/code><\/pre>\n\n\n\n
\uc2e4\ud328\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n
Query 1 \uc131\uacf5\n-> Query 2 \uc131\uacf5\n-> Query 3 \uc131\uacf5\n-> Commit \uc2e4\ud328\n-> Rollback\n-> Connection \ubc18\ud658\n<\/code><\/pre>\n\n\n\n
\uc2e4\uc81c \uac8c\uc784 \uc11c\ubc84\uc5d0\uc11c Transaction\uc774 \ud544\uc694\ud55c \uc791\uc5c5<\/h2>\n\n\n\n
\uac8c\uc784 \uc11c\ubc84\uc5d0\uc11c\ub294 Transaction\uc744 \uc0ac\uc6a9\ud560 \ub9cc\ud55c \uc791\uc5c5\uc774 \uaf64 \ub9ce\ub2e4.<\/p>\n\n\n\n
\ub300\ud45c\uc801\uc778 \uc608\uac00 \uc544\uc774\ud15c \uad6c\ub9e4\ub2e4.<\/p>\n\n\n\n
\uace8\ub4dc \ucc28\uac10\n-> \uc544\uc774\ud15c \uc9c0\uae09\n<\/code><\/pre>\n\n\n\n
\uc544\uc774\ud15c \uac15\ud654\ub3c4 \ub9c8\ucc2c\uac00\uc9c0\ub2e4.<\/p>\n\n\n\n
\uac15\ud654 \uc7ac\ub8cc \ucc28\uac10\n-> \uac15\ud654 \uacb0\uacfc \uc801\uc6a9\n<\/code><\/pre>\n\n\n\n
\uc6b0\ud3b8 \ubcf4\uc0c1 \uc218\ub839\uc774\ub77c\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \ubcfc \uc218 \uc788\ub2e4.<\/p>\n\n\n\n
\uc6b0\ud3b8 \uc0c1\ud0dc \ubcc0\uacbd\n-> \ubcf4\uc0c1 \uc9c0\uae09\n<\/code><\/pre>\n\n\n\n
\uac70\ub798 \uc2dc\uc2a4\ud15c\uc774\ub77c\uba74 \ub354 \uba85\ud655\ud558\ub2e4.<\/p>\n\n\n\n
\ud50c\ub808\uc774\uc5b4 A \uc790\uc0b0 \uac10\uc18c\n-> \ud50c\ub808\uc774\uc5b4 B \uc790\uc0b0 \uc99d\uac00\n-> \uac70\ub798 \uc0c1\ud0dc \ubcc0\uacbd\n<\/code><\/pre>\n\n\n\n
\uc774 \uc791\uc5c5 \uc911 \ud558\ub098\ub9cc \uc2e4\ud328\ud574\uc11c\ub294 \uc548 \ub41c\ub2e4.<\/p>\n\n\n\n
\uc608\ub97c \ub4e4\uc5b4 \uac70\ub798 \uacfc\uc815\uc5d0\uc11c A\uc758 \uc544\uc774\ud15c\uc740 \uc0ac\ub77c\uc84c\ub294\ub370 B\uc5d0\uac8c \ub3c8\uc774 \uc9c0\uae09\ub418\uc9c0 \uc54a\uc558\ub2e4\uba74 \uac8c\uc784 \ub370\uc774\ud130\uac00 \uae68\uc9c4\ub2e4.<\/p>\n\n\n\n
\uc774\ub7f0 \uc791\uc5c5\uc740 \uac01\uac01 \ub3c5\ub9bd\ub41c SQL\ucc98\ub7fc \ubcf4\uc774\uc9c0\ub9cc \uac8c\uc784 \ub85c\uc9c1\uc5d0\uc11c\ub294 \ud558\ub098\uc758 \uc6d0\uc790\uc801\uc778 \uc791\uc5c5\uc73c\ub85c \ucde8\uae09\ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n
\ubaa8\ub4e0 Query\ub97c Transaction\uc73c\ub85c \ucc98\ub9ac\ud558\uc9c0\ub294 \uc54a\ub294\ub2e4<\/h2>\n\n\n\n
\ubc18\ub300\ub85c \ubaa8\ub4e0 DB \uc791\uc5c5\uc744 Transaction\uc73c\ub85c \ub9cc\ub4dc\ub294 \uac83\ub3c4 \uc88b\uc740 \uad6c\uc870\ub294 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n
\ub2e8\uc21c \uc870\ud68c\ub294 \uc77c\ubc18 Query\ub85c \ucda9\ubd84\ud558\ub2e4.<\/p>\n\n\n\n
SELECT *\nFROM player_tb\nWHERE player_code = ?;\n<\/code><\/pre>\n\n\n\n
\uc774\ub7f0 \uc791\uc5c5\uae4c\uc9c0 Transaction\uc73c\ub85c \uac10\uc300 \ud544\uc694\ub294 \uc5c6\ub2e4.<\/p>\n\n\n\n
Transaction\uc740 \uc5ec\ub7ec DB \ubcc0\uacbd \uc791\uc5c5\uc758 \uc815\ud569\uc131\uc744 \ud558\ub098\uc758 \ub2e8\uc704\ub85c \ubcf4\uc7a5\ud574\uc57c \ud560 \ub54c<\/strong> \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \ubaa9\uc801\uc774\ub2e4.<\/p>\n\n\n\n
\ub530\ub77c\uc11c DB \uc811\uadfc \uacc4\uce35\uc5d0\uc11c\ub294 \ub300\ub7b5 \ub2e4\uc74c\ucc98\ub7fc \uad6c\ubd84\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n
\ub2e8\uc77c Query\n-> Query()\n\n\uc5ec\ub7ec \ubcc0\uacbd \uc791\uc5c5\uc758 \uc6d0\uc790\uc131 \ud544\uc694\n-> TransactionQuery()\n<\/code><\/pre>\n\n\n\n
Transaction \ubc94\uc704\ub294 \uc9e7\uac8c \uc720\uc9c0\ud55c\ub2e4<\/h2>\n\n\n\n
Transaction\uc5d0\uc11c \ub610 \ud558\ub098 \uc2e0\uacbd \uc368\uc57c \ud558\ub294 \ubd80\ubd84\uc740 \ubc94\uc704\ub2e4.<\/p>\n\n\n\n
Transaction\uc744 \uc2dc\uc791\ud55c \uc0c1\ud0dc\uc5d0\uc11c\ub294 Connection\uc744 \uc810\uc720\ud558\uace0 \uc788\uae30 \ub54c\ubb38\uc5d0 \ubd88\ud544\uc694\ud558\uac8c \uc624\ub798 \uc720\uc9c0\ud560 \uc774\uc720\uac00 \uc5c6\ub2e4.<\/p>\n\n\n\n
\uc608\ub97c \ub4e4\uc5b4 \ub2e4\uc74c\uacfc \uac19\uc740 \uad6c\uc870\ub294 \ud53c\ud558\ub294 \uac83\uc774 \uc88b\ub2e4.<\/p>\n\n\n\n
Begin Transaction\n-> DB Query\n-> \uc678\ubd80 API \uc694\uccad\n-> \ubcf5\uc7a1\ud55c \uacc4\uc0b0\n-> \ub2e4\ub978 \uc11c\ubc84 \uc694\uccad\n-> DB Query\n-> Commit\n<\/code><\/pre>\n\n\n\n
\uc678\ubd80 \uc11c\ubc84 \uc751\ub2f5\uc744 \uae30\ub2e4\ub9ac\ub294 \ub3d9\uc548\uc5d0\ub3c4 DB Connection\uc744 \uc7a1\uace0 \uc788\uac8c \ub41c\ub2e4.<\/p>\n\n\n\n
\ub3d9\uc2dc \uc694\uccad\uc774 \ub9ce\uc544\uc9c0\uba74 Connection Pool\uc774 \ube60\ub974\uac8c \uc18c\ubaa8\ub420 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n
\uac00\ub2a5\ud558\uba74 \ud544\uc694\ud55c \uac80\uc99d\uacfc \uacc4\uc0b0\uc744 \uba3c\uc800 \ucc98\ub9ac\ud558\uace0 \uc2e4\uc81c DB \ubcc0\uacbd\uc774 \ud544\uc694\ud55c \uc21c\uac04\uc5d0 Transaction\uc744 \uc2dc\uc791\ud558\ub294 \uac83\uc774 \uc88b\ub2e4.<\/p>\n\n\n\n
\uac80\uc99d\n-> \ub370\uc774\ud130 \uacc4\uc0b0\n-> Begin Transaction\n-> DB \ubcc0\uacbd\n-> Commit\n<\/code><\/pre>\n\n\n\n
Transaction\uc740 \uc9e7\uac8c \uac00\uc838\uac00\ub294 \ud3b8\uc774 \uc88b\ub2e4.<\/p>\n\n\n\n
\ud604\uc7ac \uad6c\uc870\uc5d0\uc11c \uc5bb\uc744 \uc218 \uc788\ub294 \uc7a5\uc810<\/h2>\n\n\n\n
\uc774 \uad6c\uc870\ub97c \ub9cc\ub4e4\uc5b4\ub450\uba74 \uac8c\uc784 \ub85c\uc9c1\uc5d0\uc11c DB \ucc98\ub9ac \ubc29\uc2dd\uc744 \ub9e4\ubc88 \uc9c1\uc811 \uad6c\ud604\ud560 \ud544\uc694\uac00 \uc5c6\ub2e4.<\/p>\n\n\n\n
\uc77c\ubc18\uc801\uc778 \uc870\ud68c\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \ucc98\ub9ac\ud55c\ub2e4.<\/p>\n\n\n\n
const player = await Query(\n    `\n        SELECT *\n        FROM player_tb\n        WHERE player_code = ?\n    `,\n    [playerCode]\n);\n<\/code><\/pre>\n\n\n\n
\uc5ec\ub7ec \ub370\uc774\ud130\ub97c \ub3d9\uc2dc\uc5d0 \ubcc0\uacbd\ud574\uc57c \ud55c\ub2e4\uba74 TransactionQuery\ub97c \uc0ac\uc6a9\ud55c\ub2e4.<\/p>\n\n\n\n
await TransactionQuery([\n    {\n        sql: \"...\",\n        options: [...]\n    },\n    {\n        sql: \"...\",\n        options: [...]\n    }\n]);\n<\/code><\/pre>\n\n\n\n
DB Connection \ud68d\ub4dd\uacfc \ubc18\ud658, Commit, Rollback, \uc608\uc678 \ucc98\ub9ac\ub294 DB \ubaa8\ub4c8 \ub0b4\ubd80\uc5d0\uc11c \ub2f4\ub2f9\ud55c\ub2e4.<\/p>\n\n\n\n
\uac8c\uc784 \ub85c\uc9c1\uc5d0\uc11c\ub294 “\uc774 \uc791\uc5c5\uc740 \ud558\ub098\uc758 Transaction\uc774\uc5b4\uc57c \ud55c\ub2e4”\ub294 \uc758\ub3c4\ub9cc \ud45c\ud604\ud558\uba74 \ub41c\ub2e4.<\/p>\n\n\n\n
\uc774\ud6c4 \uac1c\uc120\ud560 \uc218 \uc788\ub294 \ubd80\ubd84<\/h2>\n\n\n\n
\ud604\uc7ac \uad6c\ud604\uc740 \ub2e8\uc21c\ud55c \uc11c\ubc84 \uad6c\uc870\uc5d0\uc11c\ub294 \ucda9\ubd84\ud788 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc9c0\ub9cc \ud504\ub85c\uc81d\ud2b8\uac00 \ucee4\uc9c0\uba74 \uba87 \uac00\uc9c0 \uac1c\uc120\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n
\uc6b0\uc120 any<\/code>\ub97c \uc904\uc774\ub294 \uac83\uc774\ub2e4.<\/p>\n\n\n\n
options: any\n<\/code><\/pre>\n\n\n\n
\ud604\uc7ac\ub294 SQL\ub9c8\ub2e4 \ud30c\ub77c\ubbf8\ud130\uc758 \ud615\ud0dc\uac00 \ub2e4\ub974\uae30 \ub54c\ubb38\uc5d0 any<\/code>\ub97c \uc0ac\uc6a9\ud588\uc9c0\ub9cc, \ubc18\ud658 \ud0c0\uc785\uae4c\uc9c0 \uad6c\uccb4\uc801\uc73c\ub85c \uad00\ub9ac\ud55c\ub2e4\uba74 TypeScript\uc758 \ud0c0\uc785 \uc548\uc815\uc131\uc744 \ub354 \ud655\ubcf4\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n
\ub610\ud55c SQL \ubc30\uc5f4\uc744 \uc9c1\uc811 \uad6c\uc131\ud558\ub294 \ubc29\uc2dd\ub3c4 \ud504\ub85c\uc81d\ud2b8 \uaddc\ubaa8\uac00 \ucee4\uc9c0\uba74 \ud55c\uacc4\uac00 \uc788\ub2e4.<\/p>\n\n\n\n
\uc608\ub97c \ub4e4\uc5b4 \ubcf5\uc7a1\ud55c \uac8c\uc784 \ub85c\uc9c1\uc5d0\uc11c\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \ud615\ud0dc\uac00 \ub354 \ud3b8\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n
await Transaction(async (conn) => {\n\n    await updatePlayer(conn);\n\n    await consumeItem(conn);\n\n    await giveReward(conn);\n\n});\n<\/code><\/pre>\n\n\n\n
\uc774\ub807\uac8c \ud558\uba74 Transaction \ub0b4\ubd80\uc5d0\uc11c \uc2e4\ud589\ub418\ub294 \uc2e4\uc81c \uac8c\uc784 \ub85c\uc9c1\uc744 \ud568\uc218 \ub2e8\uc704\ub85c \ubd84\ub9ac\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n
\ub2e4\ub9cc \uc774\uac83\uc774 \ud604\uc7ac \uad6c\uc870\ubcf4\ub2e4 \ubb34\uc870\uac74 \uc88b\uc740 \uac83\uc740 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n
SQL \uc791\uc5c5 \uc790\uccb4\ub97c \uba85\ud655\ud558\uac8c \uad00\ub9ac\ud574\uc57c \ud558\ub294 \ud504\ub85c\uc81d\ud2b8\ub77c\uba74 \ud604\uc7ac\ucc98\ub7fc Query \ubaa9\ub85d\uc744 \uc804\ub2ec\ud558\ub294 \ubc29\uc2dd\uc774 \uc624\ud788\ub824 \ub2e8\uc21c\ud558\ub2e4.<\/p>\n\n\n\n
\uacb0\uad6d \uc911\uc694\ud55c \uac83\uc740 \ucf54\ub4dc\uc758 \ubcf5\uc7a1\ub3c4\uac00 \uc544\ub2c8\ub77c \ud504\ub85c\uc81d\ud2b8\uc5d0\uc11c DB \uc791\uc5c5\uc744 \uc5b4\ub5a4 \ub2e8\uc704\ub85c \ucd94\uc0c1\ud654\ud560 \uac83\uc778\uac00<\/strong>\ub2e4.<\/p>\n\n\n\n
\uc815\ub9ac<\/h2>\n\n\n\n
\uc774\ubc88 DB \ubaa8\ub4c8\uc758 \ud575\uc2ec\uc740 \ubcf5\uc7a1\ud558\uc9c0 \uc54a\ub2e4.<\/p>\n\n\n\n
Connection Pool\uc744 \ud558\ub098 \uc0dd\uc131\ud558\uace0 \ud544\uc694\ud55c \uc2dc\uc810\uc5d0 Connection\uc744 \uac00\uc838\uc628\ub2e4.<\/p>\n\n\n\n
\ub2e8\uc77c SQL\uc740 \uc77c\ubc18 Query\ub85c \ucc98\ub9ac\ud558\uace0, \uc5ec\ub7ec SQL\uc774 \ud558\ub098\uc758 \uc791\uc5c5 \ub2e8\uc704\ub85c \ubb36\uc5ec\uc57c \ud558\ub294 \uacbd\uc6b0 TransactionQuery\ub97c \uc0ac\uc6a9\ud55c\ub2e4.<\/p>\n\n\n\n
TransactionQuery\ub294 \ub3d9\uc77c\ud55c Connection\uc5d0\uc11c SQL\uc744 \uc21c\uc11c\ub300\ub85c \uc2e4\ud589\ud55c\ub2e4.<\/p>\n\n\n\n
\ubaa8\ub450 \uc131\uacf5\ud558\uba74 Commit\ud558\uace0 \ud558\ub098\ub77c\ub3c4 \uc2e4\ud328\ud558\uba74 Rollback\ud55c\ub2e4.<\/p>\n\n\n\n
\uadf8\ub9ac\uace0 \uc5b4\ub5a4 \uacbd\uc6b0\uc5d0\ub3c4 \ub9c8\uc9c0\ub9c9\uc5d0\ub294 Connection\uc744 Pool\uc5d0 \ubc18\ud658\ud55c\ub2e4.<\/p>\n\n\n\n
\uc804\uccb4 \ud750\ub984\uc744 \uc815\ub9ac\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n
\uc77c\ubc18 \uc791\uc5c5\n-> Pool\uc5d0\uc11c Connection \ud68d\ub4dd\n-> Query \uc2e4\ud589\n-> Connection \ubc18\ud658\n<\/code><\/pre>\n\n\n\n
Transaction \uc791\uc5c5\n-> Pool\uc5d0\uc11c Connection \ud68d\ub4dd\n-> Begin Transaction\n-> Query 1\n-> Query 2\n-> Query 3\n-> Commit\n-> Connection \ubc18\ud658\n<\/code><\/pre>\n\n\n\n
\uc2e4\ud328\ud558\ub294 \uacbd\uc6b0\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n\n\n\n
Pool\uc5d0\uc11c Connection \ud68d\ub4dd\n-> Begin Transaction\n-> Query 1\n-> Query 2 \uc2e4\ud328\n-> Rollback\n-> Connection \ubc18\ud658\n<\/code><\/pre>\n\n\n\n
\uacb0\uad6d Transaction\uc758 \ubaa9\uc801\uc740 \ub2e8\uc21c\ud788 \uc5ec\ub7ec SQL\uc744 \ubb36\ub294 \uac83\uc774 \uc544\ub2c8\ub2e4.<\/p>\n\n\n\n
\uac8c\uc784\uc5d0\uc11c \ud558\ub098\uc758 \uc791\uc5c5\uc73c\ub85c \ucde8\uae09\ud574\uc57c \ud558\ub294 \ub370\uc774\ud130 \ubcc0\uacbd\uc744 DB\uc5d0\uc11c\ub3c4 \ud558\ub098\uc758 \uc6d0\uc790\uc801\uc778 \uc791\uc5c5\uc73c\ub85c \ub9cc\ub4dc\ub294 \uac83<\/strong>\uc774\ub2e4.<\/p>\n\n\n\n
DB \uc124\uacc4\uc5d0\uc11c \uc911\uc694\ud55c \uac83\uc740 SQL\uc744 \uc5bc\ub9c8\ub098 \ub9ce\uc774 \uc54c\uace0 \uc788\ub290\ub0d0\ubcf4\ub2e4 \uc5b4\ub5a4 \ub370\uc774\ud130 \ubcc0\uacbd\uc774 \ud558\ub098\uc758 \uc791\uc5c5 \ub2e8\uc704\uc778\uc9c0 \uc815\ud655\ud558\uac8c \uc815\uc758\ud558\ub294 \uac83\uc774\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"
\uc628\ub77c\uc778 \uac8c\uc784 \uc11c\ubc84\uc5d0\uc11c DB\ub97c \ub2e4\ub8f0 \ub54c \ub2e8\uc21c\ud788 SQL\uc744 \uc2e4\ud589\ud558\ub294 \uac83\ub9cc\uc73c\ub85c \ub05d\ub098\ub294 \uacbd\uc6b0\ub294 \uc0dd\uac01\ubcf4\ub2e4 \ub9ce\uc9c0 \uc54a\ub2e4. \ud50c\ub808\uc774\uc5b4\uc758 \uc7ac\ud654\ub97c \ucc28\uac10\ud558\uace0 \uc544\uc774\ud15c\uc744 \uc9c0\uae09\ud558\uac70\ub098, \uc6b0\ud3b8\uc744 \uc0ad\uc81c\ud558\uba74\uc11c \ubcf4\uc0c1\uc744 \uc9c0\uae09\ud558\ub294 \uac83\ucc98\ub7fc \ud558\ub098\uc758 \uac8c\uc784 \ub85c\uc9c1\uc774 \uc5ec\ub7ec \uac1c\uc758 SQL\ub85c \uad6c\uc131\ub418\ub294 \uacbd\uc6b0\uac00 \ub9ce\ub2e4. \uc774\ub7f0 \uc791\uc5c5\uc5d0\uc11c \uc911\uc694\ud55c \uac83\uc740 \uac01\uac01\uc758 SQL\uc774 \uc815\uc0c1\uc801\uc73c\ub85c \uc2e4\ud589\ub418\ub294 \uac83\uc774 \uc544\ub2c8\ub77c \ud558\ub098\uc758 \uc791\uc5c5 \ub2e8\uc704\ub85c \ubaa8\ub450 \uc131\uacf5\ud558\uac70\ub098 \ubaa8\ub450 \uc2e4\ud328\ud574\uc57c \ud55c\ub2e4\ub294 \uac83\uc774\ub2e4. \uadf8\ub798\uc11c DB […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2370","post","type-post","status-publish","format-standard","hentry","category-dev-logs"],"_links":{"self":[{"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/posts\/2370","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2370"}],"version-history":[{"count":1,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/posts\/2370\/revisions"}],"predecessor-version":[{"id":2371,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=\/wp\/v2\/posts\/2370\/revisions\/2371"}],"wp:attachment":[{"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2370"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2370"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wayhope.kro.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}