{"id":1066,"date":"2020-12-06T23:20:28","date_gmt":"2020-12-06T14:20:28","guid":{"rendered":"http:\/\/leenux.kr\/?p=1066"},"modified":"2020-12-06T23:23:49","modified_gmt":"2020-12-06T14:23:49","slug":"sql-dml-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%a1%b0%ec%9e%91%ec%96%b4","status":"publish","type":"post","link":"https:\/\/leenux.kr\/?p=1066","title":{"rendered":"[SQL] DML : \ub370\uc774\ud130 \uc870\uc791\uc5b4"},"content":{"rendered":"\n<p class=\"has-text-color has-large-font-size has-very-dark-gray-color\"><strong>DML : Data Manipulation Language<\/strong><\/p>\n\n\n\n<p class=\"has-text-color has-medium-font-size has-very-dark-gray-color\"><strong>\ub370\uc774\ud130 \uc870\uc791\uc5b4(DML)\uc5d0\uc11c\ub294 SELECT, INSERT, DELETE, UPDATE \uc788\ub2e4.<\/strong><\/p>\n\n\n\n<table class=\"wp-block-table is-style-regular\"><tbody><tr><td><strong>\uba85\ub839\uc5b4<\/strong><\/td><td><strong>\uc124\uba85<\/strong><\/td><td><strong>\ubb38\ubc95<\/strong><\/td><\/tr><tr><td><strong>INSERT<\/strong><\/td><td><strong>\ub370\uc774\ud130 \uc0bd\uc785<\/strong><\/td><td><strong>INSERT INTO \ud14c\uc774\ube14\uba85 (\uceec\ub7fc1, \uceec\ub7fc2) VALUES (\uac121, \uac122);<\/strong><\/td><\/tr><tr><td><strong>SELECT<\/strong><\/td><td><strong>\ub370\uc774\ud130 \uac80\uc0c9<\/strong><\/td><td><strong>SELECT * FROM \ud14c\uc774\ube14\uba85 WHERE \uceec\ub7fc1 = \uac12;<\/strong><\/td><\/tr><tr><td><strong>DELETE<\/strong><\/td><td><strong>\ub370\uc774\ud130 \uc0ad\uc81c<\/strong><\/td><td><strong>DELECT FROM \ud14c\uc774\ube14\uba85 WHERE \uceec\ub7fc1 = \uac12;<\/strong><\/td><\/tr><tr><td><strong>UPDATE<\/strong><\/td><td><strong>\ub370\uc774\ud130 \uac31\uc2e0<\/strong><\/td><td><strong>UPDATE \ud14c\uc774\ube14\uba85 SET \uceec\ub7fc = \uac12;<\/strong><\/td><\/tr><\/tbody><\/table>\n","protected":false},"excerpt":{"rendered":"<p>DML : Data Manipulation Language \ub370\uc774\ud130 \uc870\uc791\uc5b4(DML)\uc5d0\uc11c\ub294 SELECT, INSERT, DELETE, UPDATE \uc788\ub2e4. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1069,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[27],"tags":[],"_links":{"self":[{"href":"https:\/\/leenux.kr\/index.php?rest_route=\/wp\/v2\/posts\/1066"}],"collection":[{"href":"https:\/\/leenux.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/leenux.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/leenux.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/leenux.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1066"}],"version-history":[{"count":3,"href":"https:\/\/leenux.kr\/index.php?rest_route=\/wp\/v2\/posts\/1066\/revisions"}],"predecessor-version":[{"id":1070,"href":"https:\/\/leenux.kr\/index.php?rest_route=\/wp\/v2\/posts\/1066\/revisions\/1070"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/leenux.kr\/index.php?rest_route=\/wp\/v2\/media\/1069"}],"wp:attachment":[{"href":"https:\/\/leenux.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1066"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/leenux.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1066"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/leenux.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1066"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}