{"id":123,"date":"2023-08-06T12:22:07","date_gmt":"2023-08-06T03:22:07","guid":{"rendered":"https:\/\/sejiwon.com\/?p=123"},"modified":"2023-10-23T10:52:50","modified_gmt":"2023-10-23T01:52:50","slug":"ddl-dml-dcl%ec%9d%b4%eb%9e%80","status":"publish","type":"post","link":"https:\/\/sejiwon.com\/?p=123","title":{"rendered":"DDL \/ DML \/ DCL\uc774\ub780?"},"content":{"rendered":"\n

SQL\ubb38\uc744 \ubcf4\uba74 DDL, DML\ub85c \ub098\ub258\uc5b4\uc838 \uc788\ub2e4.<\/p>\n\n\n\n

DDL(Data Definition Language), DML(Data Manipulation Language), DCL(Data Control Language)\uc758 \uc57d\uc790\uc774\ub2e4.<\/p>\n\n\n\n

<\/p>\n\n\n\n

\uccb4\uacc4\uc801\uc73c\ub85c \ucc28\uadfc\ucc28\uadfc \uacf5\ubd80\ud558\uae30 \uc88b\uc544\ud558\ub294 \uc0ac\ub78c\ub4e4\uc740 \uc774 \ub0b4\uc6a9\uc744 \uc798 \ubcf4\uace0 \uc9c0\ub098\uac00\uace0, \uc548 \uadf8\ub7f0 \uc0ac\ub78c\ub4e4\uc740 \uadf8\ub0e5 \uc9c0\ub098\uac00\ub3c4 \ub41c\ub2e4.<\/p>\n\n\n\n

\uc9c0\ub098\uac00\uc9c0\ub9cc, \ub098\uc911\uc5d0 \ub2e4\uc2dc \ub3cc\uc544\ubcf4\uac8c \ub418\uae34 \ud560 \uac83\uc774\ub2e4.<\/p>\n\n\n\n

\uc798 \uc778\uc9c0\ud558\uba74, \uc870\uae08 \ub4a4\uc5d0\uac00 \uba85\ud655\ud574 \uc9c0\uaca0\uc9c0\uc694.<\/p>\n\n\n\n

<\/p>\n\n\n\n

DDL\ubd80\ud130 \uc0b4\ud3b4\ubcf4\uc790.<\/strong><\/p>\n\n\n\n

DDL\uc740 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\uace0 \uc0ad\uc81c\ud558\uace0 \ubcc0\uacbd\ud558\ub294 \uac83\uc5d0 \ub300\ud55c \uba85\ub839\uc5b4\ub97c \ub2f4\uace0 \uc788\ub2e4.<\/p>\n\n\n\n

CREATE, DROP, MODIFY \ub4f1\uc774 \uc5ec\uae30\uc5d0 \ud574\ub2f9\ud55c\ub2e4.<\/p>\n\n\n\n

<\/p>\n\n\n\n

DML\uc740 \ud14c\uc774\ube14 \uc548\uc5d0 \ub0b4\uc6a9\uc744 \ucd94\uac00,\uc0ad\uc81c,\ubcc0\uacbd\ud558\ub294 \uc77c\uc744 \ud558\ub294 \uba85\ub839\uc5b4\ub97c \ub9d0\ud55c\ub2e4.<\/strong><\/p>\n\n\n\n

SELECT, INSERT, UPDATE, DELETE \ub4f1\uc744 \ub9d0\ud55c\ub2e4.<\/p>\n\n\n\n

<\/p>\n\n\n\n

DCL\uc740 \ubcf4\uc548, \uc801\uc6a9, \ub418\ub3cc\ub9ac\uae30 \ub4f1\uc758 \uba85\ub839\uc5b4\ub97c \ub9d0\ud55c\ub2e4.<\/strong><\/p>\n\n\n\n

COMMIT, ROLLBACK, GRANT \ub4f1\uc744 \ub9d0\ud55c\ub2e4.<\/p>\n\n\n\n

<\/p>\n\n\n\n

\uc774\ub97c \ub098\ub204\ub294 \ub370 \uac1c\ub150\uc801\uc73c\ub85c \uaf2d \uae30\uc5b5\ud574 \ub450\uba74 \uc88b\uc740 \uac83\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub0b4\uc5d0 RollBack Segment \uc601\uc5ed\uc774 \uc788\ub294\ub370 \uc774 \uc601\uc5ed\uc744 \uae30\uc5b5\ud574 \ub450\uc790. \uc774\ud558 RBS\ub77c \ud558\uaca0\ub2e4.<\/p>\n\n\n\n

RBS\ub97c \uac70\uce58\uc9c0 \uc54a\uace0, \uc2e4\ud589\ub418\ub294 \uba85\ub839\uc5b4\ub294 DDL\ubb38\uc774\ub2e4.<\/p>\n\n\n\n

DML\ubb38\uc740 RBS\uc548\uc5d0\uc11c \uc774\ub8e8\uc5b4\uc9c4\ub2e4. \ub530\ub77c\uc11c \uc774 \uc601\uc5ed\uc774 \ud06c\uba74 \uc18d\ub3c4\uac00 \ube60\ub974\ub2e4.<\/p>\n\n\n\n

DCL\uc740 RBS\uc548\uc5d0\uc11c \uc774\ub8e8\uc5b4\uc9c4 DML\ubb38\uc744 \uc801\uc6a9\ud560 \uac83\uc778\uc9c0 \ucde8\uc18c\ud560 \uac83\uc778\uc9c0\ub97c \uacb0\uc815\ud558\uace0, \ud14c\uc774\ube14\uc744 \uc5b4\ub5a4 USER\ud55c\ud14c \uc5b4\ub5a4 \uad8c\ud55c\uc73c\ub85c \ubcf4\uc5ec\uc904 \uc9c0\ub97c \uacb0\uc815\ud558\ub294 \uba85\ub839\uc774\ub2e4.<\/p>\n\n\n\n

<\/p>\n\n\n\n

\uc704 \uc14b \uc911\uc5d0\uc11c SQL\ubb38\uc774\ub77c\uace0 \uc0ac\ub78c\ub4e4\uc774 \ud754\ud788 \ub9d0\ud558\ub294 \uac83\uc740 DML \ubb38\uc774\ub2e4.<\/p>\n\n\n\n

\uc774 \ub2e4\uc74c \uae00\ubd80\ud130 \ubc30\uc6b0\uaca0\uc9c0\ub9cc, \uc704 \uc14b \uc911 \uc5b4\ub290 \ud558\ub098\ub3c4 \uba85\ub839\uc5b4\uac00 \uc5b4\ub824\uc6b4 \uac83\uc774 \uc5c6\ub2e4.<\/p>\n\n\n\n

\ud558\uc9c0\ub9cc, \ub2e8\uc21c\ud55c\ub9cc\ud07c \ub610 \uadf8 \ub2e8\uc21c\ud568\uc73c\ub85c \ucee8\ud2b8\ub864\ud558\uae30\ub3c4 \uc5b4\ub824\uc6b8 \uc218\ub3c4 \uc788\ub2e4.<\/p>\n\n\n\n

\uac19\uc740 \uc0dd\uac01\uc774\uc9c0\ub9cc, \uc790\uc2e0\uc758 \uc0dd\uac01\uc744 \uc798 \uc804\ub2ec\ud558\ub824\uba74 \ub9d0\uc744 \uc870\ub9ac\uc788\uac8c \ud574\uc57c\ud558\ub294 \uac83\ucc98\ub7fc SQL\ub3c4 \ub9ce\uc774 \uc0dd\uac01\ud558\uace0 \ud55c\uc904\ud55c\uc904 \uc791\uc131\ud558\ub294 \uac83\uc774 \uc911\uc694\ud558\ub2e4.<\/p>\n\n\n\n

\ubb50 \uc5b4\ub290\uc815\ub3c4 \uc219\ub828\uc774 \ub418\uba74 \ube60\ub974\uac8c \uc77d\uace0 \ube60\ub974\uac8c \uc791\uc131\ud558\uac8c \ub418\ub2c8\uae4c \ubbf8\ub9ac\ubd80\ud130 \uac71\uc815\ud558\uc9c0 \ub9d0\uc790.<\/p>\n\n\n\n

\uc544\ub9c8, \uc804\ubd80 \uc798 \ud558\uac8c \ub420 \uac83\uc774\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"

SQL\ubb38\uc744 \ubcf4\uba74 DDL, DML\ub85c \ub098\ub258\uc5b4\uc838 \uc788\ub2e4. DDL(Data Definition Language), DML(Data Manipulation Language), DCL(Data Control Language)\uc758 \uc57d\uc790\uc774\ub2e4. \uccb4\uacc4\uc801\uc73c\ub85c \ucc28\uadfc\ucc28\uadfc \uacf5\ubd80\ud558\uae30 \uc88b\uc544\ud558\ub294 \uc0ac\ub78c\ub4e4\uc740 \uc774 \ub0b4\uc6a9\uc744 \uc798 \ubcf4\uace0 \uc9c0\ub098\uac00\uace0, \uc548 \uadf8\ub7f0 \uc0ac\ub78c\ub4e4\uc740 \uadf8\ub0e5 \uc9c0\ub098\uac00\ub3c4 \ub41c\ub2e4. \uc9c0\ub098\uac00\uc9c0\ub9cc, \ub098\uc911\uc5d0 \ub2e4\uc2dc \ub3cc\uc544\ubcf4\uac8c \ub418\uae34 \ud560 \uac83\uc774\ub2e4. \uc798 \uc778\uc9c0\ud558\uba74, \uc870\uae08 \ub4a4\uc5d0\uac00 \uba85\ud655\ud574 \uc9c0\uaca0\uc9c0\uc694. DDL\ubd80\ud130 \uc0b4\ud3b4\ubcf4\uc790. DDL\uc740 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\uace0 \uc0ad\uc81c\ud558\uace0 \ubcc0\uacbd\ud558\ub294 \uac83\uc5d0 \ub300\ud55c \uba85\ub839\uc5b4\ub97c\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[8],"tags":[],"_links":{"self":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/123"}],"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=123"}],"version-history":[{"count":2,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/123\/revisions"}],"predecessor-version":[{"id":335,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/123\/revisions\/335"}],"wp:attachment":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}