{"id":7416,"date":"2024-09-18T14:25:32","date_gmt":"2024-09-18T14:25:32","guid":{"rendered":"https:\/\/pohang.eduwp.kr\/?p=7416"},"modified":"2026-04-20T04:31:03","modified_gmt":"2026-04-20T04:31:03","slug":"6%ec%a3%bc%ec%b0%a8-3","status":"publish","type":"post","link":"https:\/\/pohang.eduwp.kr\/?p=7416","title":{"rendered":"6\uc8fc\ucc28"},"content":{"rendered":"<p><strong>DML\u00a0 (select, insert, update, dalete)<\/strong><\/p>\n<p><strong>DDL (create, drop, alter)<\/strong><\/p>\n<p><strong>DCL (grant, revoke, deny)<\/strong><\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 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\" style=\"cursor:inherit\">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=\"\ubaa9\ucc28 \ud1a0\uae00\"><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 ' ><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/pohang.eduwp.kr\/?p=7416\/#%ED%85%8C%EC%9D%B4%EB%B8%94_%EC%9D%B4%EB%A6%84%EC%82%AC%EC%9A%A9%ED%95%A0%EB%95%8C_%EB%93%9C%EB%9E%98%EA%B7%B8%EB%A5%BC_%EC%9D%B4%EC%9A%A9%ED%95%9C_%EC%98%A4%ED%83%80_%EC%A4%84%EC%9D%B4%EA%B8%B0\" >\ud14c\uc774\ube14 \uc774\ub984\uc0ac\uc6a9\ud560\ub54c \ub4dc\ub798\uadf8\ub97c \uc774\uc6a9\ud55c \uc624\ud0c0 \uc904\uc774\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:\/\/pohang.eduwp.kr\/?p=7416\/#%EB%8C%80%EC%86%8C%EB%AC%B8%EC%9E%90_%EA%B5%AC%EB%B6%84%EC%9D%84_%ED%95%98%EC%A7%80_%EC%95%8A%EC%A7%80%EB%A7%8C_%EC%A3%BC%EC%9A%94_%ED%82%A4%EC%9B%8C%EB%93%9C%EB%A5%BC_%EB%8C%80%EB%AC%B8%EC%9E%90%EB%A1%9C_%EC%84%A4%EC%A0%95%ED%95%98%EB%8A%94_%EB%B2%95_edit_%3E_format_%3E_upcase_keyword_%E2%80%93_%EC%84%A0%ED%83%9D%ED%95%B4%EC%84%9C_%EC%A0%81%EC%9A%A9\" >\ub300\uc18c\ubb38\uc790 \uad6c\ubd84\uc744 \ud558\uc9c0 \uc54a\uc9c0\ub9cc \uc8fc\uc694 \ud0a4\uc6cc\ub4dc\ub97c \ub300\ubb38\uc790\ub85c \uc124\uc815\ud558\ub294 \ubc95 (edit &gt; format &gt; upcase keyword) &#8211; \uc120\ud0dd\ud574\uc11c \uc801\uc6a9<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/pohang.eduwp.kr\/?p=7416\/#%EC%98%88%EC%95%BD%EC%96%B4_%EC%9E%90%EB%8F%99_%EB%8C%80%EB%AC%B8%EC%9E%90_%EB%B3%80%EA%B2%BD_%ED%99%98%EA%B2%BD%EC%84%A4%EC%A0%95_%3E_sql_editor_%3E_query_editor_%3E_change_keywords_up_upper_case_%E2%80%93_%EC%98%88%EC%95%BD%EC%96%B4_%ED%9E%8C%ED%8A%B8%EC%97%90%EC%84%9C_%EC%A0%81%EC%9A%A9\" >\uc608\uc57d\uc5b4 \uc790\ub3d9 \ub300\ubb38\uc790 \ubcc0\uacbd \ud658\uacbd\uc124\uc815 &gt; sql editor &gt; query editor &gt; change keywords up upper case &#8211; \uc608\uc57d\uc5b4 \ud78c\ud2b8\uc5d0\uc11c \uc801\uc6a9<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/pohang.eduwp.kr\/?p=7416\/#%EC%BD%94%EB%93%9C_%EC%A0%95%EB%A0%AC_%ED%95%98%EA%B8%B0_ctrl_B_beauty_code\" >\ucf54\ub4dc \uc815\ub82c \ud558\uae30 ctrl + B (beauty code)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/pohang.eduwp.kr\/?p=7416\/#%EC%A3%BC%EC%84%9D_%EB%8B%A8%EC%B6%95%EA%B8%B0_ctrl\" >\uc8fc\uc11d \ub2e8\ucd95\uae30 ctrl\u00a0 + \/<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/pohang.eduwp.kr\/?p=7416\/#%EB%A6%AC%EB%AF%B8%ED%8A%B8_%EC%A0%9C%ED%95%9C_%EC%84%A4%EC%A0%95%ED%95%98%EA%B8%B0_%EA%B8%B0%EB%B3%B8%EA%B0%92%EC%9D%80_1000%ED%96%89\" >\ub9ac\ubbf8\ud2b8 \uc81c\ud55c \uc124\uc815\ud558\uae30 \uae30\ubcf8\uac12\uc740 1000\ud589<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/pohang.eduwp.kr\/?p=7416\/#%ED%8F%B0%ED%8A%B8_%ED%81%AC%EA%B8%B0_%EB%B3%80%EA%B2%BD%ED%95%98%EA%B8%B0\" >\ud3f0\ud2b8 \ud06c\uae30 \ubcc0\uacbd\ud558\uae30<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/pohang.eduwp.kr\/?p=7416\/#%EA%B2%80%EC%83%89_%EA%B2%B0%EA%B3%BC_%EA%B0%92%EC%97%90%EC%84%9C_%ED%95%84%ED%84%B0_rows_%EC%82%AC%EC%9A%A9%ED%95%98%EA%B8%B0_%EC%97%91%EC%85%80_%EC%A0%80%EC%9E%A5_%ED%95%84%ED%84%B0%EB%A7%81_%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%A7%8C_%EC%A0%80%EC%9E%A5%EB%90%98%EC%A7%80_%EC%95%8A%EA%B3%A0_%EA%B2%B0%EA%B3%BC%EA%B0%92%EC%9D%B4_%EB%AA%A8%EB%91%90_%EC%A0%80%EC%9E%A5_csv%EB%A5%BC_%EA%B0%80%EC%9E%A5_%EB%A7%8E%EC%9D%B4_%EC%82%AC%EC%9A%A9\" >\uac80\uc0c9 \uacb0\uacfc \uac12\uc5d0\uc11c \ud544\ud130 rows \uc0ac\uc6a9\ud558\uae30\u00a0 \u00a0\uc5d1\uc140 \uc800\uc7a5 (\ud544\ud130\ub9c1 \ub370\uc774\ud130\ub9cc \uc800\uc7a5\ub418\uc9c0 \uc54a\uace0 \uacb0\uacfc\uac12\uc774 \ubaa8\ub450 \uc800\uc7a5 csv\ub97c \uac00\uc7a5 \ub9ce\uc774 \uc0ac\uc6a9)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/pohang.eduwp.kr\/?p=7416\/#update_%EB%AA%85%EB%A0%B9%EC%96%B4\" >update \uba85\ub839\uc5b4<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/pohang.eduwp.kr\/?p=7416\/#DELETE_%EB%AA%85%EB%A0%B9%EC%96%B4\" >DELETE \uba85\ub839\uc5b4<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/pohang.eduwp.kr\/?p=7416\/#mysql_%EC%9C%A0%EC%A0%80_%EC%B6%94%EA%B0%80%ED%95%98%EA%B8%B0_DCL_%EB%AA%85%EB%A0%B9%EC%96%B4\" >mysql \uc720\uc800 \ucd94\uac00\ud558\uae30 (DCL \uba85\ub839\uc5b4)<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/pohang.eduwp.kr\/?p=7416\/#%EC%83%9D%EC%84%B1%EB%AA%85%EB%A0%B9_%ED%8C%A8%EC%8A%A4%EC%9B%8C%EB%93%9C_%EB%B3%80%EA%B2%BD_%EC%82%AC%EC%9A%A9%EC%9E%90%EC%82%AD%EC%A0%9C\" >\uc0dd\uc131\uba85\ub839, \ud328\uc2a4\uc6cc\ub4dc \ubcc0\uacbd, \uc0ac\uc6a9\uc790\uc0ad\uc81c<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/pohang.eduwp.kr\/?p=7416\/#%EA%B6%8C%ED%95%9C_%EB%B3%B4%EA%B8%B0\" >\uad8c\ud55c \ubcf4\uae30<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%ED%85%8C%EC%9D%B4%EB%B8%94_%EC%9D%B4%EB%A6%84%EC%82%AC%EC%9A%A9%ED%95%A0%EB%95%8C_%EB%93%9C%EB%9E%98%EA%B7%B8%EB%A5%BC_%EC%9D%B4%EC%9A%A9%ED%95%9C_%EC%98%A4%ED%83%80_%EC%A4%84%EC%9D%B4%EA%B8%B0\"><\/span>\ud14c\uc774\ube14 \uc774\ub984\uc0ac\uc6a9\ud560\ub54c \ub4dc\ub798\uadf8\ub97c \uc774\uc6a9\ud55c \uc624\ud0c0 \uc904\uc774\uae30<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"%EB%8C%80%EC%86%8C%EB%AC%B8%EC%9E%90_%EA%B5%AC%EB%B6%84%EC%9D%84_%ED%95%98%EC%A7%80_%EC%95%8A%EC%A7%80%EB%A7%8C_%EC%A3%BC%EC%9A%94_%ED%82%A4%EC%9B%8C%EB%93%9C%EB%A5%BC_%EB%8C%80%EB%AC%B8%EC%9E%90%EB%A1%9C_%EC%84%A4%EC%A0%95%ED%95%98%EB%8A%94_%EB%B2%95_edit_%3E_format_%3E_upcase_keyword_%E2%80%93_%EC%84%A0%ED%83%9D%ED%95%B4%EC%84%9C_%EC%A0%81%EC%9A%A9\"><\/span>\ub300\uc18c\ubb38\uc790 \uad6c\ubd84\uc744 \ud558\uc9c0 \uc54a\uc9c0\ub9cc \uc8fc\uc694 \ud0a4\uc6cc\ub4dc\ub97c \ub300\ubb38\uc790\ub85c \uc124\uc815\ud558\ub294 \ubc95 (edit &gt; format &gt; upcase keyword) &#8211; \uc120\ud0dd\ud574\uc11c \uc801\uc6a9<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"%EC%98%88%EC%95%BD%EC%96%B4_%EC%9E%90%EB%8F%99_%EB%8C%80%EB%AC%B8%EC%9E%90_%EB%B3%80%EA%B2%BD_%ED%99%98%EA%B2%BD%EC%84%A4%EC%A0%95_%3E_sql_editor_%3E_query_editor_%3E_change_keywords_up_upper_case_%E2%80%93_%EC%98%88%EC%95%BD%EC%96%B4_%ED%9E%8C%ED%8A%B8%EC%97%90%EC%84%9C_%EC%A0%81%EC%9A%A9\"><\/span>\uc608\uc57d\uc5b4 \uc790\ub3d9 \ub300\ubb38\uc790 \ubcc0\uacbd \ud658\uacbd\uc124\uc815 &gt; sql editor &gt; query editor &gt; change keywords up upper case &#8211; \uc608\uc57d\uc5b4 \ud78c\ud2b8\uc5d0\uc11c \uc801\uc6a9<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"%EC%BD%94%EB%93%9C_%EC%A0%95%EB%A0%AC_%ED%95%98%EA%B8%B0_ctrl_B_beauty_code\"><\/span>\ucf54\ub4dc \uc815\ub82c \ud558\uae30 ctrl + B (beauty code)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"%EC%A3%BC%EC%84%9D_%EB%8B%A8%EC%B6%95%EA%B8%B0_ctrl\"><\/span>\uc8fc\uc11d \ub2e8\ucd95\uae30 ctrl\u00a0 + \/<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"%EB%A6%AC%EB%AF%B8%ED%8A%B8_%EC%A0%9C%ED%95%9C_%EC%84%A4%EC%A0%95%ED%95%98%EA%B8%B0_%EA%B8%B0%EB%B3%B8%EA%B0%92%EC%9D%80_1000%ED%96%89\"><\/span>\ub9ac\ubbf8\ud2b8 \uc81c\ud55c \uc124\uc815\ud558\uae30 \uae30\ubcf8\uac12\uc740 1000\ud589<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"%ED%8F%B0%ED%8A%B8_%ED%81%AC%EA%B8%B0_%EB%B3%80%EA%B2%BD%ED%95%98%EA%B8%B0\"><\/span>\ud3f0\ud2b8 \ud06c\uae30 \ubcc0\uacbd\ud558\uae30<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"%EA%B2%80%EC%83%89_%EA%B2%B0%EA%B3%BC_%EA%B0%92%EC%97%90%EC%84%9C_%ED%95%84%ED%84%B0_rows_%EC%82%AC%EC%9A%A9%ED%95%98%EA%B8%B0_%EC%97%91%EC%85%80_%EC%A0%80%EC%9E%A5_%ED%95%84%ED%84%B0%EB%A7%81_%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%A7%8C_%EC%A0%80%EC%9E%A5%EB%90%98%EC%A7%80_%EC%95%8A%EA%B3%A0_%EA%B2%B0%EA%B3%BC%EA%B0%92%EC%9D%B4_%EB%AA%A8%EB%91%90_%EC%A0%80%EC%9E%A5_csv%EB%A5%BC_%EA%B0%80%EC%9E%A5_%EB%A7%8E%EC%9D%B4_%EC%82%AC%EC%9A%A9\"><\/span>\uac80\uc0c9 \uacb0\uacfc \uac12\uc5d0\uc11c \ud544\ud130 rows \uc0ac\uc6a9\ud558\uae30\u00a0 \u00a0\uc5d1\uc140 \uc800\uc7a5 (\ud544\ud130\ub9c1 \ub370\uc774\ud130\ub9cc \uc800\uc7a5\ub418\uc9c0 \uc54a\uace0 \uacb0\uacfc\uac12\uc774 \ubaa8\ub450 \uc800\uc7a5 csv\ub97c \uac00\uc7a5 \ub9ce\uc774 \uc0ac\uc6a9)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n<h1><span class=\"ez-toc-section\" id=\"update_%EB%AA%85%EB%A0%B9%EC%96%B4\"><\/span>update \uba85\ub839\uc5b4<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>&nbsp;<\/p>\n<p>\ud14c\uc774\ud130\ub97c \uac80\uc0c9\ud574\uc11c \ubc14\uafb8\uace0\uc790 \ud558\ub294 \ub370\uc774\ud130\ub97c \uba3c\uc800 \uc870\ud68c\ud55c\ub2e4.<\/p>\n<p>\ubc14\uafb8\uace0\uc790 \ud558\ub294 \ub370\uc774\ud130\uc758 \uc870\uac74\uc2dd\uc744 \ub9cc\ub4e4\uc5b4\uc11c \ub370\uc774\ud130\uc758 \ub0b4\uc6a9\uc744 \ubcc0\uacbd\ud55c\ub2e4.<\/p>\n<p>update \ud14c\uc774\ube14\ubcd1 set \uc218\uc815\ud558\uace0\uc2f6\uc740\uceec\ub7fc\uba85 = \uc218\uc815\ud558\uace0\uc2f6\uc740\uac12 where \ud2b9\uc815\uceec\ub7fc =&#8217;\uac12&#8217;;<\/p>\n<p>&nbsp;<\/p>\n<p>buytbl \ud14c\uc774\ube14\uc5d0\uc11c \uc0ac\uc6a9\uc790ID\uac00 JYP\uc778 \uc0ac\ub78c\uc744 \uac80\uc0c9\ud574\uc11c pordName\uc758 \ub370\uc774\ud130\uac12\uc744 \ubaa8\ub2c8\ud1302\ub85c \ubcc0\uacbd\ud55c\ub2e4.<\/p>\n<p>\ub9cc\uc77c \uc0ac\uc6a9\uc790\uac00 ID\uac00 jyp\uac00 \uc5ec\ub7ec\uba85 \uc77c \uacbd\uc6b0 (id\uac00 \ud504\ub77c\uc774\uba38\ub9ac\ud0a4\uac00 \uc544\ub2c8\ub77c \uc77c\ubc18 \ud14d\uc2a4\ud2b8\uc77c\uacbd\uc6b0 \uc911\ubcf5\uc77c \uc218\ub3c4 \uc788\ub2e4.)<\/p>\n<p>\ubcf5\uc218\uc758 \ub370\uc774\ud130 \uac12\uc774 \ubcc0\uacbd\ub41c\ub2e4. \uc774\ub7f0 \uacbd\uc6b0\ub294 \uc124\uacc4 \uc624\ub958\ub77c\uace0 \ubcfc \uc218 \uc788\ub2e4. ID\uac12\uc740 2\uba85\uc774 \uc874\uc7ac\ud558\uac8c \uc124\uacc4\ud55c \uacbd\uc6b0 \ubcf5\uc218\ub85c \uc5c5\ub370\uc774\ud2b8\uac00 \uc9c4\ud589\ub41c\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">update buytbl set prodName = '\ubaa8\ub2c8\ud1302' where userID ='JYP';<\/pre>\n<p>&nbsp;<\/p>\n<p>\ud14c\uc774\ube14\uc774\ub098 db\ub97c \ubcf5\uc0ac\ud574\uc11c \ud14c\uc2a4\ud2b8\ud558\uae30<\/p>\n<p>\ubaa8\ub4e0 \ud544\ub4dc\uc758 \uac12\uc744 \ud55c\ubc88\uc5d0 \ubcc0\uacbd\ud558\uae30 , \uc2e4\uc218\ub97c \ud558\uae30 \uc27d\uae30 \ub54c\ubb38\uc5d0 \ub9e4\uc6b0 \uc870\uc2ec\ud574\uc57c\ud55c\ub2e4. where\uad6c\ubb38\uc774 \uc5c6\uc774 \uadf8\ub0e5 \uba85\ub839\uc5b4\ub97c \uc801\uc6a9\ud558\uba74<\/p>\n<p>\ud544\ub4dc\uac12\uc774 \ud55c\uaebc\ubc88\uc5d0 \ubcc0\uacbd\ub418\uae30 \ub54c\ubb38\uc5d0 \uc2e0\uc911\uc5d0 \uc2e0\uc911\uc744 \ud574\uc57c \ud55c\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">update \ud14c\uc774\ube14\uba85 set name ='';\r\n\r\nupdate \ud14c\uc774\ube14\uba85 set lname='' where fname ='\uae38\ub3d9';<\/pre>\n<p>&nbsp;<\/p>\n<hr \/>\n<h1><span class=\"ez-toc-section\" id=\"DELETE_%EB%AA%85%EB%A0%B9%EC%96%B4\"><\/span>DELETE \uba85\ub839\uc5b4<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>delete from \ud14c\uc774\ube14\uba85 where \uc870\uc2dd\uc2dd;<\/p>\n<p>\ub370\uc774\ud130\ub97c \uba3c\uc800 \uac80\uc0c9\ud558\uac70\ub098 \uc870\uc2dd\uc2dd\uc744 \ub9cc\ub4e4\uc5b4\uc11c 1\ud589\uc774\ub098 \ubcf5\uc218\ud589\uc744 \uc0ad\uc81c\ud560 \uc218 \uc788\ub2e4.<\/p>\n<p>\uc774\ub54c \uc8fc\uc758\ud560 \uc810\uc740 \uc870\uac74\uc2dd\uc774 \ub9de\uc73c\uba74 \ub3d9\uc2dc\uc5d0 \uc0ad\uc81c\ub420 \uc218 \uc788\ub2e4\ub294 \uc810\uc744 \uace0\ub824\ud574\uc57c \ud568<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">-- \ub370\uc774\ud130 \uc911 prodName \uceec\ub7fc\uc5d0 \ubaa8\ub2c8\ud1302 \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud574\uc11c \uc0ad\uc81c\ud55c\ub2e4. \uc911\ubcf5 \uc0ad\uc81c \uac00\ub2a5--\r\n\r\ndelete from buytbl where prodName = '\ubaa8\ub2c8\ud1302';\r\n\r\n\r\n\r\n\r\n-- \ub370\uc774\ud130 \uc911 id\uac12\uc774 1\ubc88\uc778 \ub370\uc774\ud130\ub97c \uc0ad\uc81c --\r\n\r\ndelete from buytbl where id = 1;<\/pre>\n<hr \/>\n<h1><span class=\"ez-toc-section\" id=\"mysql_%EC%9C%A0%EC%A0%80_%EC%B6%94%EA%B0%80%ED%95%98%EA%B8%B0_DCL_%EB%AA%85%EB%A0%B9%EC%96%B4\"><\/span>mysql \uc720\uc800 \ucd94\uac00\ud558\uae30 (DCL \uba85\ub839\uc5b4)<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>mysql \ucee4\uba58\ub4dc \ubaa8\ub4dc\uc5d0\uc11c user \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\ub97c \uc811\uadfc<\/p>\n<p>testuser \uc544\uc774\ub514\uc5d0 \ud328\uc2a4\uc6cc\ub4dc 1234\ub85c \uc720\uc800 \uc544\uc774\ub514 \ucd94\uac00, 2\uac00\uc9c0 \ubc29\ubc95 \ucc28\uc774 \uc54c\uae30<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%EC%83%9D%EC%84%B1%EB%AA%85%EB%A0%B9_%ED%8C%A8%EC%8A%A4%EC%9B%8C%EB%93%9C_%EB%B3%80%EA%B2%BD_%EC%82%AC%EC%9A%A9%EC%9E%90%EC%82%AD%EC%A0%9C\"><\/span>\uc0dd\uc131\uba85\ub839, \ud328\uc2a4\uc6cc\ub4dc \ubcc0\uacbd, \uc0ac\uc6a9\uc790\uc0ad\uc81c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">-- \uc720\uc800\ucd94\uac00\r\n\r\nmysql &gt; create user 'testuser'@localhost identified by '1234';\r\n\r\n\r\n- \ud328\uc2a4\uc6cc\ub4dc \ubcc0\uacbd\r\n\r\nmysql &gt; set password for 'testuser'@localhost = '12345678';\r\n\r\n\r\n- \ud328\uc2a4\uc6cc\ub4dc\uac00 \ubcc0\uacbd\ub41c \uac83\uc740 mysql \uc5d0\uc11c \ube60\uc838\ub098\uc640\uc11c \ub2e4\uc2dc \ub85c\uadf8\uc778\uc744 \ud574\uc11c \ud655\uc778\ud55c\ub2e4.\r\n\r\n\r\n\uc0ac\uc6a9\uc790\uc0ad\uc81c\r\n\r\nmysql &gt; drop user 'testuser'@localhost;\r\n\r\n<\/pre>\n<p>&nbsp;<\/p>\n<h1><span class=\"ez-toc-section\" id=\"%EA%B6%8C%ED%95%9C_%EB%B3%B4%EA%B8%B0\"><\/span>\uad8c\ud55c \ubcf4\uae30<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>grant \uba85\ub839\uc5b4\ub85c \uc544\uc774\ub514\ubcc4\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ud14c\uc774\ube14\uc758 \uad8c\ud55c\uc744 \ubd80\uc5ec\ud560 \uc218 \uc788\ub2e4.<\/p>\n<p>\uc804\uccb4 \ubd80\uc5ec\ub294 *.*; \uc73c\ub85c \ucc98\ub9ac<\/p>\n<p>grant all on dbname.tableName;<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">mysql &gt; grant all on *.*;\r\n\r\nmysql &gt; show grants for 'testuser'@localhost;\r\n\r\nmysql &gt; grant all on shopdb.usertbl to 'testuser'@localhost;\r\n\r\nmysql &gt; grant select, update on shopdb.usertbl to 'testuser'@localhost;\r\n\r\n-- shopdb\uc758 usertbl \ud14c\uc774\ube14\ub9cc select, update \uad8c\ud55c\uc744 \ubd80\uc5ec\ud55c\ub2e4.<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DML\u00a0 (select, insert, update, dalete) DDL (create, drop, alter) DCL (grant, revoke, deny) &nbsp; \ud14c\uc774\ube14 \uc774\ub984\uc0ac\uc6a9\ud560\ub54c \ub4dc\ub798\uadf8\ub97c \uc774\uc6a9\ud55c \uc624\ud0c0 \uc904\uc774\uae30 \ub300\uc18c\ubb38\uc790 \uad6c\ubd84\uc744 \ud558\uc9c0 \uc54a\uc9c0\ub9cc \uc8fc\uc694 \ud0a4\uc6cc\ub4dc\ub97c \ub300\ubb38\uc790\ub85c \uc124\uc815\ud558\ub294 \ubc95 (edit&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30],"tags":[],"class_list":["post-7416","post","type-post","status-publish","format-standard","category-mysql"],"_links":{"self":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts\/7416","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7416"}],"version-history":[{"count":5,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts\/7416\/revisions"}],"predecessor-version":[{"id":7471,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts\/7416\/revisions\/7471"}],"wp:attachment":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}