{"id":445,"date":"2025-03-18T14:59:33","date_gmt":"2025-03-18T05:59:33","guid":{"rendered":"https:\/\/sejiwon.com\/?p=445"},"modified":"2025-03-18T14:59:33","modified_gmt":"2025-03-18T05:59:33","slug":"%ed%8c%8c%ec%9d%b4%ec%8d%ac%ec%9c%bc%eb%a1%9c-%ec%97%91%ec%85%80%ec%97%90-%ec%bb%ac%eb%9f%bc%ea%b8%b0%ec%a4%80%ec%9c%bc%eb%a1%9c-sql%ed%8c%8c%ec%9d%bc%eb%a1%9c-%eb%a7%8c%eb%93%a4%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/sejiwon.com\/?p=445","title":{"rendered":"\ud30c\uc774\uc36c\uc73c\ub85c \uc5d1\uc140\uc5d0 \uceec\ub7fc\uae30\uc900\uc73c\ub85c SQL\ud30c\uc77c\ub85c \ub9cc\ub4e4\uae30"},"content":{"rendered":"\n<p>\uc5c5\ubb34\ub97c \ud558\ub2e4\ubcf4\uba74 \uc5d1\uc140 \ubb38\uc11c\uc5d0 \ud14c\uc774\ube14 \uc815\uc758\uc11c \ub4f1\uc744 \uc774\uc6a9\ud558\uc5ec \ucffc\ub9ac\ub97c \uc791\uc131\ud574\uc57c \ud560 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc778\ud130\ub137\uc774 \ub418\ub294 \ud658\uacbd\uc774\ub77c\uba74 \uac04\ub2e8\ud558\uac8c \ud30c\uc774\uc36c \uc18c\uc2a4\ub85c \uc774\ub97c \ud574\uacb0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \uc5d1\uc140\ud30c\uc77c\uc5d0\uc11c \uc77d\uc5b4\uc11c .sql\uc744 \ub9cc\ub4dc\ub294 \uc790\ub3d9\ud654\r\n\r\n# \uc5d1\uc140\uc744 \uc77d\ub294\ub2e4.\r\nimport openpyxl as op\r\n\r\n# \uc77d\uc5b4\uc62c \uc5d1\uc140\ud30c\uc77c\r\nfilePath = \"C:\/Users\/sejiw\/OneDrive\/\ubb38\uc11c\/\uc2e0\uc6a9\uc815\ubcf4\uc6d0\/dbSample.xlsx\"\r\n\r\n# WorkBook \uac1d\uccb4\uc0dd\uc131\r\nwp = op.load_workbook(filePath)\r\n\r\n# \uac1d\uccb4 \uc0dd\uc131\r\nws = wp.active\r\n\r\n# File Open\r\nsf = open(\"C:\/Users\/sejiw\/OneDrive\/\ubb38\uc11c\/\uc2e0\uc6a9\uc815\ubcf4\uc6d0\/test.sql\", \"w\")\r\n\r\n# Loop\ubcc0\uc218 \ucd08\uae30\ud654\r\ni = 0\r\n\r\n# \ub9c8\uc9c0\ub9c9 row\uae4c\uc9c0 \uc77d\uae30\r\nfor r in ws.rows:\r\n\r\n# row, column \uc22b\uc790\ub85c \uc811\uadfc\ud558\uae30\r\n    i = i + 1\r\n\r\n    column = ws.cell(row = i, column = 3).value\r\n    table  = ws.cell(row = i, column = 2).value\r\n\r\n    if i == 1 :\r\n        sf.write(\" \" + \"\\n\")\r\n\r\n    if i == 2 :\r\n        sf.write(\"SELECT \" + column + \"\\n\")\r\n\r\n    if i > 2 :\r\n        sf.write(\"      ,\" + column + \"\\n\")\r\n\r\nsf.write(\"  FROM \" + table + \"\\n\")\r\n\r\nsf.close()\n\n<\/code><\/pre>\n\n\n\n<p>\uc704\uc640 \uac19\uc774 \uac04\ub2e8\ud55c \ucf54\ub4dc\ub85c SQL \ud30c\uc77c\uc744 \uc791\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc5c5\ubb34\ub97c \ud558\ub2e4\ubcf4\uba74 \uc5d1\uc140 \ubb38\uc11c\uc5d0 \ud14c\uc774\ube14 \uc815\uc758\uc11c \ub4f1\uc744 \uc774\uc6a9\ud558\uc5ec \ucffc\ub9ac\ub97c \uc791\uc131\ud574\uc57c \ud560 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc778\ud130\ub137\uc774 \ub418\ub294 \ud658\uacbd\uc774\ub77c\uba74 \uac04\ub2e8\ud558\uac8c \ud30c\uc774\uc36c \uc18c\uc2a4\ub85c \uc774\ub97c \ud574\uacb0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc704\uc640 \uac19\uc774 \uac04\ub2e8\ud55c \ucf54\ub4dc\ub85c SQL \ud30c\uc77c\uc744 \uc791\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/445"}],"collection":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=445"}],"version-history":[{"count":1,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/445\/revisions"}],"predecessor-version":[{"id":446,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/445\/revisions\/446"}],"wp:attachment":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=445"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}