{"id":20482,"date":"2018-04-05T11:16:00","date_gmt":"2018-04-05T02:16:00","guid":{"rendered":"http:\/\/w3devlabs.net\/wp\/?p=20482"},"modified":"2018-03-22T20:16:52","modified_gmt":"2018-03-22T11:16:52","slug":"13-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-13-2-sql-%eb%a7%9b%eb%b3%b4%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/w3devlabs.net\/wp\/?p=20482","title":{"rendered":"13. \ub370\uc774\ud130\ubca0\uc774\uc2a4 13.2 SQL \ub9db\ubcf4\uae30"},"content":{"rendered":"

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

13.2 SQL \ub9db\ubcf4\uae30<\/font><\/font><\/span><\/h2>\n

SQL\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub370\uc774\ud130\ub97c \uc81c\uc5b4\ud558\uae30 \uc704\ud55c \uc5b8\uc5b4\uc785\ub2c8\ub2e4. \uc704\ud0a4\uc5d0\uc11c \uc815\uc758 \ub97c \ubcf4\uba74 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

\u201cSQL(Structured Query Language, \uad6c\uc870\ud654 \uc9c8\uc758\uc5b4, S-Q-L)\ub294 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c(RDBMS)\uc758 \ub370\uc774\ud130\ub97c \uad00\ub9ac\ud558\uae30 \uc704\ud574 \uc124\uacc4\ub41c \ud2b9\uc218 \ubaa9\uc801\uc758 \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\uc774\ub2e4. \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc5d0\uc11c \uc790\ub8cc\uc758 \uac80\uc0c9\uacfc \uad00\ub9ac, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2a4\ud0a4\ub9c8 \uc0dd\uc131\uacfc \uc218\uc815, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac1d\uccb4 \uc811\uadfc \uc870\uc815 \uad00\ub9ac\ub97c \uc704\ud574 \uace0\uc548\ub418\uc5c8\ub2e4. \ub9ce\uc740 \uc218\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub828 \ud504\ub85c\uadf8\ub7a8\ub4e4\uc774 SQL\uc744 \ud45c\uc900\uc73c\ub85c \ucc44\ud0dd\ud558\uace0 \uc788\ub2e4.\u201d<\/font><\/span><\/p>\n


<\/p>\n

\uc6b0\ub9ac\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ub2e4\ub8e8\uae30 \uc704\ud574\uc11c\ub294 SQL\ubb38\uc7a5\uc744 \uc774\uc6a9\ud574\uc11c \ub2e4\ub8e8\uc5b4\uc57c \ud569\ub2c8\ub2e4. <\/font><\/span><\/p>\n

\uc6b0\ub9ac\uac00 \ubc30\uc6cc\uc57c\ud560 \uae30\ubcf8\uc801\uc778 SQL\uc740 SELECT, INSERT, UPDATE, DELETE\uc785\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

13.2.1 SELECT<\/font><\/font><\/span><\/h3>\n


<\/p>\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\ub294\ub370 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. <\/font><\/span><\/p>\n

SELECT \uceec\ub7fc\uba85 FROM \ud14c\uc774\ube14\uba85 WHERE \uc870\uac74<\/font><\/span><\/p>\n

\uc704\uc640 \uac19\uc774 \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\ub294\uac83\uc785\ub2c8\ub2e4. <\/font><\/span><\/p>\n




<\/p>\n

13.2.2 INSERT<\/font><\/font><\/span><\/h3>\n

INSERT \ubb38\uc740 \ub370\uc774\ud130\ub97c \uc785\ub825\ud558\ub294\ub370 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. <\/font><\/span><\/p>\n

INSERT INTO \ud14c\uc774\ube14\uba85 (\uceec\ub7fc\uba85)  VALUES(\uc785\ub825\ud560 \ub370\uc774\ud130)<\/font><\/span><\/p>\n

\uc704\uc640\uac19\uc774 \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \ucd94\uac00\ud569\ub2c8\ub2e4. <\/font><\/span><\/p>\n





<\/p>\n

13.2.3 UPDATE<\/font><\/font><\/span><\/h3>\n

UPDATE \ubb38\uc740 \uc774\ubbf8 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc874\uc7ac\ud558\ub294\ub370\uc774\ud130\uc758 \ub0b4\uc6a9\uc744 \ubc14\uafb8\uae30 \uc704\ud574 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. <\/font><\/span><\/p>\n

UPDATE \ud14c\uc774\ube14\uba85 SET \uceec\ub7fc\uba85 = \ubcc0\uacbd\ud560 \ub370\uc774\ud130 WHERE \uc870\uac74<\/font><\/span><\/p>\n

\uc704\uc640\uac19\uc740 \ubc29\ubc95\uc73c\ub85c \uae30\uc874\uc5d0 \uc788\ub294 \ub370\uc774\ud130\ub97c \ubcc0\uacbd\ud569\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

13.2.4 DELETE<\/font><\/font><\/span><\/h3>\n

DELETE\ub294 \ud544\uc694\uc5c6\uc5b4\uc9c4 \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ud558\ub294\uac83\uc785\ub2c8\ub2e4. <\/font><\/span><\/p>\n

DELETE FROM \ud14c\uc774\ube14\uba85 WHERE \uc870\uac74<\/font><\/span><\/p>\n

\uc704\uc640\uac19\uc740 \ubc29\ubc95\uc744 \uc774\uc6a9\ud558\uc5ec \uae30\uc874\uc5d0 \ub370\uc774\ud130\ub97c \uc644\uc804\ud788 \uc0ad\uc81c\ud569\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.2 SQL \ub9db\ubcf4\uae30 SQL\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub370\uc774\ud130\ub97c \uc81c\uc5b4\ud558\uae30 \uc704\ud55c \uc5b8\uc5b4\uc785\ub2c8\ub2e4. \uc704\ud0a4\uc5d0\uc11c \uc815\uc758 \ub97c \ubcf4\uba74 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. \u201cSQL(Structured Query Language, \uad6c\uc870\ud654 \uc9c8\uc758\uc5b4, S-Q-L)\ub294 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c(RDBMS)\uc758 \ub370\uc774\ud130\ub97c \uad00\ub9ac\ud558\uae30 \uc704\ud574 \uc124\uacc4\ub41c \ud2b9\uc218 \ubaa9\uc801\uc758 \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\uc774\ub2e4. \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc5d0\uc11c \uc790\ub8cc\uc758 \uac80\uc0c9\uacfc \uad00\ub9ac, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2a4\ud0a4\ub9c8 \uc0dd\uc131\uacfc \uc218\uc815, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac1d\uccb4 \uc811\uadfc \uc870\uc815 \uad00\ub9ac\ub97c \uc704\ud574 \uace0\uc548\ub418\uc5c8\ub2e4. … <\/p>\n

\ub354 \ubcf4\uae30 “13. \ub370\uc774\ud130\ubca0\uc774\uc2a4 13.2 SQL \ub9db\ubcf4\uae30”<\/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,24394,5291,5625],"class_list":["post-20482","post","type-post","status-publish","format-standard","hentry","category-5836","tag-python","tag-sql","tag-5291","tag-5625","entry"],"_links":{"self":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/20482","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=20482"}],"version-history":[{"count":1,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/20482\/revisions"}],"predecessor-version":[{"id":20483,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/20482\/revisions\/20483"}],"wp:attachment":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=20482"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=20482"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=20482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}