{"id":1170,"date":"2016-01-03T10:03:17","date_gmt":"2016-01-03T10:03:17","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1170"},"modified":"2016-01-03T10:03:17","modified_gmt":"2016-01-03T10:03:17","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-%ec%a0%9c%ec%95%bd%ec%a1%b0%ea%b1%b4","status":"publish","type":"post","link":"https:\/\/haisins.synology.me\/wordpress\/?p=1170","title":{"rendered":"\uc624\ub77c\ud074 \uc81c\uc57d\uc870\uac74"},"content":{"rendered":"

\uc81c\uc57d \uc870\uac74(Constraints)\uc758 \uc815\uc758 <\/SPAN><\/P>
\n

\ud14c\uc774\ube14\uc5d0 \ucd94\uac00, \ubcc0\uacbd, \uc0ad\uc81c\ub418\ub294 \ub370\uc774\ud130\ub97c \uc81c\uc57d. <\/SPAN><\/P>
\n

\uc81c\uc57d \uc870\uac74\uc758 \ud544\uc694\uc131 <\/SPAN><\/P>
\n

\ub370\uc774\ud130\uc758 \ubb34\uacb0\uc131(Integrity)\uc744 \uc720\uc9c0\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9. <\/SPAN><\/P>
\n

\uc81c\uc57d \uc870\uac74\uc758 \uc885\ub958 <\/SPAN><\/P>
\n

UNIQUE (UK) : \uc911\ubcf5\ub41c \uac12\uc744 \ud5c8\uc6a9\ud558\uc9c0 \uc54a\uc74c. <\/SPAN><\/P>
\n

NOT NULL (NN) : NULL \uac12\uc744 \ud5c8\uc6a9\ud558\uc9c0 \uc54a\uc74c. <\/SPAN><\/P>
\n

PRIMARY KEY (PK) : UNIQUE\uc640 NOT NULL\uc758 \uc870\uac74\uc744 \ub9cc\uc871\ud558\ub294 \uac12 \ud5c8\uc6a9. <\/SPAN><\/P>
\n

FOREIGN KEY (FK) – \ucc38\uc870\ud558\ub294 \ud14c\uc774\ube14\uc758 \uce7c\ub7fc\uc758 \uac12\uc774 \uc874\uc7ac\ud558\uba74 \uac12 \ud5c8\uc6a9. <\/SPAN><\/P>
\n

CHECK (CK) – \uc81c\uc57d\uc870\uac74\uc744 \uc124\uc815\ud560 \ub54c \uc124\uc815\ud55c \uac12\ub9cc\uc744 \ubc1b\uc544\ub4e4\uc784. <\/SPAN><\/P>
\n

Merge <\/SPAN><\/P>
\n

\uc815\uc758 – \ud558\ub098 \ud639\uc740 \uadf8 \uc774\uc0c1\uc758 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c INSERT, UPDATE \uc791\uc5c5\uc744 <\/SPAN><\/P>
\n

\uc704\ud574 \ud558\ub098 \ud639\uc740 \uadf8 \uc774\uc0c1\uc758 \uc18c\uc2a4\ub85c\ubd80\ud130 \uc9c8\uc758\ud560 \ub54c \uc0ac\uc6a9\ud558\ub294 \uba85\ub839\uc5b4. <\/SPAN><\/P>
\n

\ubb38\ubc95 <\/SPAN><\/P>
\n

MERGE INTO \ud14c\uc774\ube14\uc774\ub984 <\/SPAN><\/P>
\n

USING SELECT statement.. <\/SPAN><\/P>
\n

ON \uc870\uac74 <\/SPAN><\/P>
\n

WHEN MATCHED THEN <\/SPAN><\/P>
\n

UPDATE statement <\/SPAN><\/P>
\n

[DELETE statement <\/SPAN><\/P>
\n

WHEN NOT MATCHED THEN <\/SPAN><\/P>
\n

INSERT statement <\/SPAN><\/P>
\n

[WHERE \uc808]; <\/SPAN><\/P><\/p>\n","protected":false},"excerpt":{"rendered":"

\uc81c\uc57d \uc870\uac74(Constraints)\uc758 \uc815\uc758 \ud14c\uc774\ube14\uc5d0 \ucd94\uac00, \ubcc0\uacbd, \uc0ad\uc81c\ub418\ub294 \ub370\uc774\ud130\ub97c \uc81c\uc57d. \uc81c\uc57d \uc870\uac74\uc758 \ud544\uc694\uc131 \ub370\uc774\ud130\uc758 \ubb34\uacb0\uc131(Integrity)\uc744 \uc720\uc9c0\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9. \uc81c\uc57d \uc870\uac74\uc758 \uc885\ub958 UNIQUE (UK) : \uc911\ubcf5\ub41c \uac12\uc744 \ud5c8\uc6a9\ud558\uc9c0 \uc54a\uc74c. NOT NULL (NN) : NULL \uac12\uc744 \ud5c8\uc6a9\ud558\uc9c0 \uc54a\uc74c. PRIMARY KEY (PK) : UNIQUE\uc640 NOT NULL\uc758 \uc870\uac74\uc744 \ub9cc\uc871\ud558\ub294 \uac12 \ud5c8\uc6a9. FOREIGN KEY (FK) – \ucc38\uc870\ud558\ub294 \ud14c\uc774\ube14\uc758 \uce7c\ub7fc\uc758 \uac12\uc774 \uc874\uc7ac\ud558\uba74 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[9],"tags":[658,659],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1170"}],"collection":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1170"}],"version-history":[{"count":0,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1170\/revisions"}],"wp:attachment":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}