{"id":1169,"date":"2016-01-03T10:03:03","date_gmt":"2016-01-03T10:03:03","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1169"},"modified":"2016-01-03T10:03:03","modified_gmt":"2016-01-03T10:03:03","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-%ed%8a%b8%eb%9e%9c%ec%9e%ad%ec%85%98insert","status":"publish","type":"post","link":"https:\/\/haisins.synology.me\/wordpress\/?p=1169","title":{"rendered":"\uc624\ub77c\ud074 \ud2b8\ub79c\uc7ad\uc158(Insert)"},"content":{"rendered":"

\ud2b8\ub79c\uc7ad\uc158: \ud55c \uc791\uc5c5\uc758 \ub2e8\uc704 <\/SPAN><\/P>
\n

commit, rollback <\/SPAN><\/P>
\n

   <\/P>
\n

\ub370\uc774\ud130 \ucd94\uac00 – INSERT<\/STRONG> <\/SPAN><\/P>
\n

INSERT INTO \ud14c\uc774\ube14\uc774\ub984 (\uce7c\ub7fc\uc774\ub9841, \uce7c\ub7fc\uc774\ub9842, ..) <\/SPAN><\/P>
\n

VALUES (\uac121, \uac122, ..); <\/SPAN><\/P>
\n

\uc608. ‘IT Education’\uc774\ub77c\ub294 \uc2e0\uaddc \ubd80\uc11c\ub97c \ubd80\uc11c\ubc88\ud638 280\uc73c\ub85c \ubd80\uc11c(department) \ud14c\uc774\ube14\uc5d0 \ub4f1\ub85d\ud558\uc790. <\/SPAN><\/P>
\n

SQL> INSERT INTO departments(department_id,department_name) <\/SPAN><\/P>
\n

VALUES(280, ‘IT Education’); <\/SPAN><\/P>
\n

   <\/P>
\n

INSERT INTO \ud14c\uc774\ube14\uc774\ub984(\uce7c\ub7fc\uc774\ub9841, \uce7c\ub7fc\uc774\ub9842, ..) <\/SPAN><\/P>
\n

SELECT statement; <\/SPAN><\/P>
\n

\uc608. \uc601\uc5c5 \ubd80\uc11c\uc5d0 \uc18d\ud55c \uc0ac\uc6d0\uc5d0 \ub300\ud574 10%\uc758 \uae09\uc5ec \uc778\uc0c1. <\/SPAN><\/P>
\n

SQL> INSERT INTO bonuses <\/SPAN><\/P>
\n

SELECT employee_id, salary * 0.1 FROM employees; <\/SPAN><\/P>
\n

SQL> COMMIT; <\/SPAN><\/P>
\n

   <\/P>
\n

INSERT [ALL \\ FIRST] <\/STRONG><\/SPAN><\/P>
\n

WHEN \uc870\uac741 THEN<\/STRONG> <\/SPAN><\/P>
\n

INTO \ud14c\uc774\ube14\uc774\ub9841<\/STRONG> <\/SPAN><\/P>
\n

WHEN \uc870\uac742 THEN<\/STRONG> <\/SPAN><\/P>
\n

INTO \ud14c\uc774\ube14\uc774\ub9842<\/STRONG> <\/SPAN><\/P>
\n

ELSE<\/STRONG> <\/SPAN><\/P>
\n

INTO \ud14c\uc774\ube14\uc774\ub9843<\/STRONG> <\/SPAN><\/P>
\n

SELECT Statement;<\/STRONG> <\/SPAN><\/P>
\n

   <\/P>
\n

\uc608. \uc8fc\ubb38 \ub0b4\uc5ed\uc5d0 \ub300\ud55c \uc5f0\ub3c4\ubcc4 \uad00\ub9ac \uc791\uc5c5. <\/SPAN><\/P>
\n

SQL> INSERT ALL <\/SPAN><\/P>
\n

WHEN TO_CHAR(order_date, ‘YYYY’) = ‘1990’ THEN <\/SPAN><\/P>
\n

INTO order_1990 <\/SPAN><\/P>
\n

~ <\/SPAN><\/P>
\n

WHEN TO_CHAR(order_date, ‘YYYY’) = ‘1999’ THEN <\/SPAN><\/P>
\n

INTO order_1999 <\/SPAN><\/P>
\n

WHEN TO_CHAR(order_date, ‘YYYY’) = ‘2000’ THEN <\/SPAN><\/P>
\n

INTO order_2000 <\/SPAN><\/P>
\n

SELECT order_id, order_date, customer_id, order_total, sales_rep_id <\/SPAN><\/P>
\n

FROM orders; <\/SPAN><\/P>
\n

   <\/P>
\n

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

\ud2b8\ub79c\uc7ad\uc158: \ud55c \uc791\uc5c5\uc758 \ub2e8\uc704 commit, rollback     \ub370\uc774\ud130 \ucd94\uac00 – INSERT INSERT INTO \ud14c\uc774\ube14\uc774\ub984 (\uce7c\ub7fc\uc774\ub9841, \uce7c\ub7fc\uc774\ub9842, ..) VALUES (\uac121, \uac122, ..); \uc608. ‘IT Education’\uc774\ub77c\ub294 \uc2e0\uaddc \ubd80\uc11c\ub97c \ubd80\uc11c\ubc88\ud638 280\uc73c\ub85c \ubd80\uc11c(department) \ud14c\uc774\ube14\uc5d0 \ub4f1\ub85d\ud558\uc790. SQL> INSERT INTO departments(department_id,department_name) VALUES(280, ‘IT Education’);     INSERT INTO \ud14c\uc774\ube14\uc774\ub984(\uce7c\ub7fc\uc774\ub9841, \uce7c\ub7fc\uc774\ub9842, ..) SELECT statement; \uc608. \uc601\uc5c5 \ubd80\uc11c\uc5d0 \uc18d\ud55c \uc0ac\uc6d0\uc5d0 \ub300\ud574 10%\uc758 […]<\/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":[155,156],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1169"}],"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=1169"}],"version-history":[{"count":0,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1169\/revisions"}],"wp:attachment":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}