{"id":20494,"date":"2018-04-08T11:09:00","date_gmt":"2018-04-08T02:09:00","guid":{"rendered":"http:\/\/w3devlabs.net\/wp\/?p=20494"},"modified":"2018-03-22T20:24:57","modified_gmt":"2018-03-22T11:24:57","slug":"13-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-13-8-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%82%ad%ec%a0%9c","status":"publish","type":"post","link":"http:\/\/w3devlabs.net\/wp\/?p=20494","title":{"rendered":"13. \ub370\uc774\ud130\ubca0\uc774\uc2a4 13.8 \ub370\uc774\ud130 \uc0ad\uc81c"},"content":{"rendered":"

C\uae09 \uac1c\ubc1c\uc790\uc640 \ud568\uaed8\ud558\ub294 \ud30c\uc774\uc36c<\/h2>\n

13.8 \ub370\uc774\ud130 \uc0ad\uc81c<\/font><\/font><\/span><\/h2>\n

\ub370\uc774\ud130\ub97c \uc785\ub825\ud558\uace0 \uc218\uc815\ud558\uace0 \uac80\uc0c9\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uc558\uc2b5\ub2c8\ub2e4. \uc774\uc81c\ub294 \uc0ac\uc6a9\ud558\ub2e4\uac00 \ud544\uc694\uc5c6\uc5b4\uc9c4 \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

\u201c\uc774\uc720\uc8002\u201d\ub77c\ub294 \uace0\uac1d\uc774 \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ud574\ub2ec\ub77c\ub294 \uc694\uccad\uc744 \ud558\uc600\uc2b5\ub2c8\ub2e4. \uc774\ub7f0\uacbd\uc6b0 \uc5b4\ub5bb\uac8c \uc0ad\uc81c\ud560\uae4c\uc694? <\/font><\/span><\/p>\n


<\/p>\n

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


<\/p>\n

\uc704\uc5d0\uc11c\ub294 \uc774\uc720\uc8002\ub77c\ub294 \uace0\uac1d\uc758 \uc815\ubcf4\ub97c \uc0ad\uc81c\ud558\uae30 \uc704\ud574\uc11c <\/font><\/span><\/p>\n


<\/p>\n

DELETE FROM CUSTOMER WHERE USER_ID = \u2018user1\u2019<\/font><\/span><\/p>\n


<\/p>\n

\uc704\uc640 \uac19\uc740 \ucffc\ub9ac\ub97c \uc774\uc6a9\ud558\uc600\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

\uc774\uc804\uc758 \ub0b4\uc6a9\uc744 \ubcf4\uace0 \uc720\ucd94\ud560\uc218 \uc788\ub4ef\uc774 <\/font><\/span><\/p>\n


<\/p>\n

DELETE <\/font><\/span>\t<\/span><\/span><\/font><- \uc0ad\uc81c\ud558\ub77c<\/font><\/span><\/p>\n

FROM CUSTOMER<\/font><\/span>\t<\/span><\/span><\/font><- CUSTOMER \ud14c\uc774\ube14\uc5d0\uc11c<\/font><\/span><\/p>\n

WHERE USER_ID = \u2018user1\u2019<\/font><\/span>\t<\/span><\/span><\/font><- \uc870\uac74\uc774 USER_ID = \u2018user1\u2019\uc778 \ub370\uc774\ud130\ub97c<\/font><\/span><\/p>\n


<\/p>\n

\uc774\ub807\uac8c \ud558\uba74 \uc6d0\ud558\ub294 \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

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



<\/p>\n

13.99 \uc694\uc57d <\/font><\/font><\/span><\/h2>\n


<\/p>\n

\uc704\uc5d0\uc11c \uc6b0\ub9ac\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub370\uc774\ud130\ub97c \uc785\ub825, \uc218\uc815, \uc0ad\uc81c \uadf8\ub9ac\uace0 \uac80\uc0c9\uc744 \uc54c\uc544\ubcf4\uc558\uc2b5\ub2c8\ub2e4. \ucc98\uc74c \ubcf4\uba74 \ubb34\uc2a8\ub9d0\uc778\uc9c0 \ub0af\uc124\uace0 \uc5b4\ub835\uac8c \ub290\uaef4\uc9c8\uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc6b0\ub9ac\uac00 \uc544\ub294 \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\uc640\ub294 \ub2e4\ub978 \ud615\ud0dc\ub97c \uac00\uc9c0\uace0 \uc788\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

\uadf8\ub7ec\ub098 \uc774\ub7f0  SQL\uc740 ORACLE, MSSQL, MYSQL\ub4f1 \uc774\uc678\uc758 RDBMS\uc5d0\uc11c \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\uae30 \ub54c\ubb38\uc5d0 \uc704\uc758 \ucffc\ub9ac\ubb38\uc744 \uc798 \uc775\ud600\ub450\uba74 \ub2e4\ub978 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c\ub3c4 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

\uc6b0\ub9ac\uac00 \uc0ac\uc6a9\ud558\ub294 \ub300\ubd80\ubd84\uc758 \ud504\ub85c\uadf8\ub7a8\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc774\uc6a9\ud569\ub2c8\ub2e4. \uc774\ubc88 \uc7a5\uc5d0\uc11c \ubc30\uc6b4 \ub0b4\uc6a9\uc744 \uc798 \uc219\uc9c0\ud558\uc5ec  \uc774\ud6c4 \ud504\ub85c\uadf8\ub798\ubc0d\uc744 \ud558\ub294\ub370 \ub3c4\uc6c0\uc774 \ub418\uae30\ub97c \ubc14\ub78d\ub2c8\ub2e4.<\/font><\/span><\/p>\n


<\/p>\n","protected":false},"excerpt":{"rendered":"

C\uae09 \uac1c\ubc1c\uc790\uc640 \ud568\uaed8\ud558\ub294 \ud30c\uc774\uc36c 13.8 \ub370\uc774\ud130 \uc0ad\uc81c \ub370\uc774\ud130\ub97c \uc785\ub825\ud558\uace0 \uc218\uc815\ud558\uace0 \uac80\uc0c9\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uc558\uc2b5\ub2c8\ub2e4. \uc774\uc81c\ub294 \uc0ac\uc6a9\ud558\ub2e4\uac00 \ud544\uc694\uc5c6\uc5b4\uc9c4 \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. \u201c\uc774\uc720\uc8002\u201d\ub77c\ub294 \uace0\uac1d\uc774 \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ud574\ub2ec\ub77c\ub294 \uc694\uccad\uc744 \ud558\uc600\uc2b5\ub2c8\ub2e4. \uc774\ub7f0\uacbd\uc6b0 \uc5b4\ub5bb\uac8c \uc0ad\uc81c\ud560\uae4c\uc694? \uc704\uc5d0\uc11c\ub294 \uc774\uc720\uc8002\ub77c\ub294 \uace0\uac1d\uc758 \uc815\ubcf4\ub97c \uc0ad\uc81c\ud558\uae30 \uc704\ud574\uc11c DELETE FROM CUSTOMER WHERE USER_ID = \u2018user1\u2019 \uc704\uc640 \uac19\uc740 \ucffc\ub9ac\ub97c \uc774\uc6a9\ud558\uc600\uc2b5\ub2c8\ub2e4. \uc774\uc804\uc758 \ub0b4\uc6a9\uc744 \ubcf4\uace0 \uc720\ucd94\ud560\uc218 \uc788\ub4ef\uc774 DELETE <- … <\/p>\n

\ub354 \ubcf4\uae30 “13. \ub370\uc774\ud130\ubca0\uc774\uc2a4 13.8 \ub370\uc774\ud130 \uc0ad\uc81c”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[5836],"tags":[16211,5291,24400,5625],"class_list":["post-20494","post","type-post","status-publish","format-standard","hentry","category-5836","tag-python","tag-5291","tag-24400","tag-5625","entry"],"_links":{"self":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/20494","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=20494"}],"version-history":[{"count":1,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/20494\/revisions"}],"predecessor-version":[{"id":20495,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/20494\/revisions\/20495"}],"wp:attachment":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=20494"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=20494"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=20494"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}