{"id":238,"date":"2024-05-21T07:24:15","date_gmt":"2024-05-21T07:24:15","guid":{"rendered":"https:\/\/youngrihan.com\/?p=238"},"modified":"2024-05-20T12:24:30","modified_gmt":"2024-05-20T12:24:30","slug":"%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ea%b8%b0%ec%b4%88-%ec%95%8c%ec%95%84%eb%b3%b4%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/youngrihan.com\/%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ea%b8%b0%ec%b4%88-%ec%95%8c%ec%95%84%eb%b3%b4%ea%b8%b0\/","title":{"rendered":"\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uae30\ucd08 \uc54c\uc544\ubcf4\uae30"},"content":{"rendered":"<p>\ud604\ub300\uc758 \ub370\uc774\ud130 \uc911\uc2ec \ud658\uacbd\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \ubc0f \uc870\uc791 \ub2a5\ub825\uc740 \ud544\uc218\uc801\uc778 \uae30\uc220\ub85c \uc790\ub9ac\uc7a1\uc558\uc2b5\ub2c8\ub2e4. \uc774 \uc911 SQL(Structured Query Language)\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uace0 \uc870\uc791\ud558\uae30 \uc704\ud55c \uac15\ub825\ud55c \ub3c4\uad6c\uc785\ub2c8\ub2e4. SQL\uc740 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc800\uc7a5, \uc218\uc815, \uac80\uc0c9\ud558\ub294 \ub370 \uc0ac\uc6a9\ub418\ub294 \ud45c\uc900 \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\uc785\ub2c8\ub2e4. \ubcf8 \uae00\uc5d0\uc11c\ub294 SQL\uc758 \uae30\ucd08\uc640 \uadf8 \uc911\uc694\uc131, SQL\uc744 \uc2dc\uc791\ud558\uae30 \uc704\ud55c \uae30\ubcf8 \uac1c\ub150\uc744 \uc18c\uac1c\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_68_1 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/youngrihan.com\/%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ea%b8%b0%ec%b4%88-%ec%95%8c%ec%95%84%eb%b3%b4%ea%b8%b0\/#SQL%EC%9D%98_%EC%A4%91%EC%9A%94%EC%84%B1_%EC%9D%B4%ED%95%B4%ED%95%98%EA%B8%B0\" title=\"SQL\uc758 \uc911\uc694\uc131 \uc774\ud574\ud558\uae30\">SQL\uc758 \uc911\uc694\uc131 \uc774\ud574\ud558\uae30<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/youngrihan.com\/%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ea%b8%b0%ec%b4%88-%ec%95%8c%ec%95%84%eb%b3%b4%ea%b8%b0\/#SQL_%EA%B8%B0%EC%B4%88\" title=\"SQL \uae30\ucd08\">SQL \uae30\ucd08<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/youngrihan.com\/%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ea%b8%b0%ec%b4%88-%ec%95%8c%ec%95%84%eb%b3%b4%ea%b8%b0\/#SQL_%EA%B8%B0%EC%B4%88-2\" title=\"SQL \uae30\ucd08\">SQL \uae30\ucd08<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/youngrihan.com\/%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ea%b8%b0%ec%b4%88-%ec%95%8c%ec%95%84%eb%b3%b4%ea%b8%b0\/#SQL_%EA%B3%A0%EA%B8%89_%EA%B8%B0%EB%8A%A5\" title=\"SQL \uace0\uae09 \uae30\ub2a5\">SQL \uace0\uae09 \uae30\ub2a5<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/youngrihan.com\/%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ea%b8%b0%ec%b4%88-%ec%95%8c%ec%95%84%eb%b3%b4%ea%b8%b0\/#%EA%B2%B0%EB%A1%A0\" title=\"\uacb0\ub860\">\uacb0\ub860<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"SQL%EC%9D%98_%EC%A4%91%EC%9A%94%EC%84%B1_%EC%9D%B4%ED%95%B4%ED%95%98%EA%B8%B0\"><\/span>SQL\uc758 \uc911\uc694\uc131 \uc774\ud574\ud558\uae30<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>SQL\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc758 \ud575\uc2ec \uc5b8\uc5b4\ub85c, \ub2e4\uc591\ud55c \uc0b0\uc5c5 \ubd84\uc57c\uc5d0\uc11c \ub110\ub9ac \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc870\uc9c1\uc5d0\uc11c \uc815\ubcf4\ub97c \uc800\uc7a5\ud558\ub294 \uc911\uc694\ud55c \uc218\ub2e8\uc774\uba70, SQL\uc744 \uc0ac\uc6a9\ud558\uba74 \uc774 \ub370\uc774\ud130\uc5d0 \uc27d\uac8c \uc811\uadfc\ud558\uace0, \uc774\ub97c \uae30\ubc18\uc73c\ub85c \uc758\uc0ac\uacb0\uc815\uc744 \ub0b4\ub9b4 \uc218 \uc788\ub294 \uc720\uc6a9\ud55c \uc778\uc0ac\uc774\ud2b8\ub97c \uc81c\uacf5\ubc1b\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. SQL\uc740 \ub370\uc774\ud130\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \ucc98\ub9ac\ud558\uace0 \ubd84\uc11d\ud558\ub294 \ub370 \ud544\uc218\uc801\uc774\uba70, \ube44\uc988\ub2c8\uc2a4 \uc778\ud154\ub9ac\uc804\uc2a4, \ub9c8\ucf00\ud305, \uae08\uc735 \ubd84\uc11d \ub4f1 \ub2e4\uc591\ud55c \uc5ed\ud560\uc5d0\uc11c \uc694\uad6c\ub418\ub294 \uae30\uc220\uc785\ub2c8\ub2e4.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"SQL_%EA%B8%B0%EC%B4%88\"><\/span>SQL \uae30\ucd08<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>SQL\uc758 \uae30\ubcf8\uc744 \uc774\ud574\ud558\ub294 \uac83\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\uc758 \uc0c1\ud638\uc791\uc6a9\uc744 \uc2dc\uc791\ud558\ub294 \ub370 \uccab\uac78\uc74c\uc785\ub2c8\ub2e4. SQL\uc758 \ub370\uc774\ud130 \uc870\uc791 \uc5b8\uc5b4(DML)\ub294 \ub370\uc774\ud130\ub97c \uc2e4\uc81c\ub85c \ucc98\ub9ac\ud558\ub294 SQL \uba85\ub839\uc5b4\uc758 \uc9d1\ud569\uc73c\ub85c, \uc8fc\ub85c SELECT, INSERT, UPDATE, DELETE \ub4f1\uc758 \uba85\ub839\uc5b4\ub97c \ud3ec\ud568\ud569\ub2c8\ub2e4. SELECT \uba85\ub839\uc5b4\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ud2b9\uc815 \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud560 \ub54c \uc0ac\uc6a9\ub418\uba70, INSERT\ub294 \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ub97c \ucd94\uac00, UPDATE\ub294 \uae30\uc874 \ub370\uc774\ud130\ub97c \uc218\uc815, DELETE\ub294 \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"SQL_%EA%B8%B0%EC%B4%88-2\"><\/span>SQL \uae30\ucd08<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\ub370\uc774\ud130 \uc815\uc758 \uc5b8\uc5b4(DDL)\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2a4\ud0a4\ub9c8\ub97c \uc0dd\uc131, \ubcc0\uacbd, \uc0ad\uc81c\ud558\ub294 \ub370 \uc0ac\uc6a9\ub418\ub294 SQL\uc758 \ubd80\ubd84\uc785\ub2c8\ub2e4. \uc774\uc5d0\ub294 CREATE, ALTER, DROP \ub4f1\uc758 \uba85\ub839\uc5b4\uac00 \ud3ec\ud568\ub429\ub2c8\ub2e4. CREATE\ub294 \uc0c8\ub85c\uc6b4 \ud14c\uc774\ube14\uc774\ub098 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud560 \ub54c, ALTER\ub294 \ud14c\uc774\ube14 \uad6c\uc870\ub97c \ubcc0\uacbd\ud560 \ub54c, DROP\uc740 \ud14c\uc774\ube14\uc774\ub098 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ad\uc81c\ud560 \ub54c \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \uc774 \uba85\ub839\uc5b4\ub4e4\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uad6c\uc870\ub97c \uc124\uacc4\ud558\uace0, \ud544\uc694\uc5d0 \ub530\ub77c \uc774 \uad6c\uc870\ub97c \uc870\uc815\ud558\ub294 \ub370 \ud544\uc218\uc801\uc785\ub2c8\ub2e4.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"SQL_%EA%B3%A0%EA%B8%89_%EA%B8%B0%EB%8A%A5\"><\/span>SQL \uace0\uae09 \uae30\ub2a5<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>SQL\uc758 \ub2a5\ub825\uc744 \ud655\uc7a5\ud558\ub294 \uace0\uae09 \uae30\ub2a5\uc744 \uc774\ud574\ud558\ub294 \uac83\uc740 \ub370\uc774\ud130 \ubd84\uc11d\uc758 \ubcf5\uc7a1\ud55c \uc694\uad6c\ub97c \ucda9\uc871\uc2dc\ud0ac \uc218 \uc788\uac8c \ud569\ub2c8\ub2e4. \uc870\uc778(Join)\uc740 \ub450 \ud14c\uc774\ube14 \uc774\uc0c1\uc744 \uc5f0\uacb0\ud558\uc5ec \ub370\uc774\ud130\ub97c \uacb0\ud569\ud560 \ub54c \uc0ac\uc6a9\ub418\uba70, \uc11c\ube0c\ucffc\ub9ac\ub294 \ucffc\ub9ac \ub0b4\uc5d0 \ub2e4\ub978 \ucffc\ub9ac\ub97c \ud3ec\ud568\uc2dc\ucf1c \ubcf4\ub2e4 \ub3d9\uc801\uc778 \ub370\uc774\ud130 \uac80\uc0c9\uc744 \uac00\ub2a5\ud558\uac8c \ud569\ub2c8\ub2e4. \ub610\ud55c, \ubcf5\uc7a1\ud55c \uc870\uac74\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \ud544\ud130\ub9c1\ud558\uace0 \uc815\ub82c\ud558\ub294 \uae30\ub2a5\ub3c4 SQL\uc758 \uc911\uc694\ud55c \ubd80\ubd84\uc785\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uace0\uae09 \uae30\ub2a5\ub4e4\uc740 \ubcf4\ub2e4 \uc815\uad50\ud55c \ub370\uc774\ud130 \ubd84\uc11d\uacfc \ubcf4\uace0\uc11c \uc791\uc131\uc744 \uac00\ub2a5\ud558\uac8c \ud569\ub2c8\ub2e4.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%EA%B2%B0%EB%A1%A0\"><\/span>\uacb0\ub860<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>SQL\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uace0 \ucd5c\ub300\ud55c \ud65c\uc6a9\ud560 \uc218 \uc788\ub3c4\ub85d \ud574\uc8fc\ub294 \uac15\ub825\ud55c \ub3c4\uad6c\uc785\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c \ub2e4\ub8ec SQL\uc758 \uae30\ubcf8 \uac1c\ub150\uacfc \uace0\uae09 \uae30\ub2a5\ub4e4\uc744 \ud1b5\ud574 \ub3c5\uc790 \uc5ec\ub7ec\ubd84\uc774 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc758 \uae30\ucd08\ub97c \ud0c4\ud0c4\ud788 \ub2e4\uc9c8 \uc218 \uc788\uae30\ub97c \ubc14\ub78d\ub2c8\ub2e4. \ub370\uc774\ud130 \uc2dc\ub300\uc5d0\uc11c SQL \ub2a5\ub825\uc740 \ub9e4\uc6b0 \uc911\uc694\ud558\ubbc0\ub85c, \uc774 \uae30\ud68c\ub97c \ud1b5\ud574 SQL \ud559\uc2b5\uc744 \uc2dc\uc791\ud558\uace0, \uc5ec\ub7ec\ubd84\uc758 \uacbd\ub825 \ub610\ub294 \ube44\uc988\ub2c8\uc2a4\uc5d0 \uc2e4\uc9c8\uc801\uc778 \uac00\uce58\ub97c \ub354\ud574 \ubcf4\uc138\uc694.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ud604\ub300\uc758 \ub370\uc774\ud130 \uc911\uc2ec \ud658\uacbd\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \ubc0f \uc870\uc791 \ub2a5\ub825\uc740 \ud544\uc218\uc801\uc778 \uae30\uc220\ub85c \uc790\ub9ac\uc7a1\uc558\uc2b5\ub2c8\ub2e4. \uc774 \uc911 SQL(Structured Query Language)\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uace0 \uc870\uc791\ud558\uae30 \uc704\ud55c \uac15\ub825\ud55c \ub3c4\uad6c\uc785\ub2c8\ub2e4. SQL\uc740 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc800\uc7a5, \uc218\uc815, \uac80\uc0c9\ud558\ub294 \ub370 \uc0ac\uc6a9\ub418\ub294 \ud45c\uc900 \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\uc785\ub2c8\ub2e4. \ubcf8 \uae00\uc5d0\uc11c\ub294 SQL\uc758 \uae30\ucd08\uc640 \uadf8 \uc911\uc694\uc131, SQL\uc744 \uc2dc\uc791\ud558\uae30 \uc704\ud55c \uae30\ubcf8 \uac1c\ub150\uc744 \uc18c\uac1c\ud558\uaca0\uc2b5\ub2c8\ub2e4. SQL\uc758 \uc911\uc694\uc131 \uc774\ud574\ud558\uae30 SQL\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4&hellip;&nbsp;<a href=\"https:\/\/youngrihan.com\/%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ea%b8%b0%ec%b4%88-%ec%95%8c%ec%95%84%eb%b3%b4%ea%b8%b0\/\" class=\"\" rel=\"bookmark\">\ub354 \ubcf4\uae30 &raquo;<span class=\"screen-reader-text\">\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uae30\ucd08 \uc54c\uc544\ubcf4\uae30<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":239,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_lock_modified_date":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[16],"tags":[27],"class_list":["post-238","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-program-development","tag-27"],"_links":{"self":[{"href":"https:\/\/youngrihan.com\/wp-json\/wp\/v2\/posts\/238"}],"collection":[{"href":"https:\/\/youngrihan.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/youngrihan.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/youngrihan.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/youngrihan.com\/wp-json\/wp\/v2\/comments?post=238"}],"version-history":[{"count":1,"href":"https:\/\/youngrihan.com\/wp-json\/wp\/v2\/posts\/238\/revisions"}],"predecessor-version":[{"id":240,"href":"https:\/\/youngrihan.com\/wp-json\/wp\/v2\/posts\/238\/revisions\/240"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/youngrihan.com\/wp-json\/wp\/v2\/media\/239"}],"wp:attachment":[{"href":"https:\/\/youngrihan.com\/wp-json\/wp\/v2\/media?parent=238"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/youngrihan.com\/wp-json\/wp\/v2\/categories?post=238"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/youngrihan.com\/wp-json\/wp\/v2\/tags?post=238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}