{"id":1680,"date":"2024-02-01T17:53:41","date_gmt":"2024-02-01T08:53:41","guid":{"rendered":"https:\/\/dohokin.com\/?p=1680"},"modified":"2024-02-01T17:53:42","modified_gmt":"2024-02-01T08:53:42","slug":"create-table-ddl-%ec%9d%98%eb%af%b8","status":"publish","type":"post","link":"https:\/\/dohokin.com\/?p=1680","title":{"rendered":"CREATE TABLE (DDL) \uc758\ubbf8"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/dohokin.com\/wp-content\/uploads\/2024\/02\/image-1.png\" alt=\"\" class=\"wp-image-1684\"\/><\/figure>\n\n\n\n<p>DDL\uc740 <strong>Data Definition Language<\/strong>\uc758 \uc57d\uc790\ub85c, \ub370\uc774\ud130 \uc815\uc758 \uc5b8\uc5b4\ub97c \uc758\ubbf8\ud569\ub2c8\ub2e4. DDL\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2a4\ud0a4\ub9c8\ub97c \uc815\uc758\ud558\uac70\ub098 \ubcc0\uacbd\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\ub418\ub294 SQL(Structured Query Language)\uc758 \ud55c \ubd80\ubd84\uc785\ub2c8\ub2e4. DDL \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4, \ud14c\uc774\ube14, \uc778\ub371\uc2a4 \ub4f1\uc758 \uad6c\uc870\ub97c \uc0dd\uc131, \ubcc0\uacbd, \uc0ad\uc81c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. DDL\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uad6c\uc870\ub97c \ub2e4\ub8e8\ub294 \ub370 \ucd08\uc810\uc744 \ub9de\ucd94\uace0 \uc788\uc73c\uba70, \uc2e4\uc81c \ub370\uc774\ud130\uc758 \ucd94\uac00, \uc218\uc815, \uc0ad\uc81c \ub4f1\uc740 \ub370\uc774\ud130 \uc870\uc791 \uc5b8\uc5b4(DML) \uba85\ub839\uc5b4\ub97c \ud1b5\ud574 \uc218\ud589\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>DDL\uc758 \uc8fc\uc694 \uba85\ub839\uc5b4\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uac83\ub4e4\uc774 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n\n\n\n<ul>\n<li><strong>CREATE<\/strong>: \ub370\uc774\ud130\ubca0\uc774\uc2a4, \ud14c\uc774\ube14, \uc778\ub371\uc2a4 \ub4f1\uc758 \uc0c8\ub85c\uc6b4 \uad6c\uc870\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>ALTER<\/strong>: \uae30\uc874\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad6c\uc870\ub97c \uc218\uc815\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>DROP<\/strong>: \ub370\uc774\ud130\ubca0\uc774\uc2a4, \ud14c\uc774\ube14, \uc778\ub371\uc2a4 \ub4f1\uc744 \uc0ad\uc81c\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>TRUNCATE<\/strong>: \ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ud558\uc9c0\ub9cc, \ud14c\uc774\ube14 \uad6c\uc870\ub294 \uc720\uc9c0\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<p>DDL \uba85\ub839\uc5b4\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uba54\ud0c0\ub370\uc774\ud130\ub97c \uc815\uc758\ud558\uac70\ub098 \ubcc0\uacbd\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\ub418\uba70, \uc774\ub7ec\ud55c \ubcc0\uacbd\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uad6c\uc870\uc801\uc778 \uce21\uba74\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4. DDL\uc744 \uc0ac\uc6a9\ud560 \ub54c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc124\uacc4\ub098 \uad6c\uc870 \ubcc0\uacbd\uacfc \uad00\ub828\ub41c \uc791\uc5c5\uc744 \uc218\ud589\ud558\uac8c \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p><code><br>SQL_SAFE_UPDATES<\/code>\ub294 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 \uc124\uc815 \uc911 \ud558\ub098\ub85c, \ub370\uc774\ud130\uc758 \uc2e4\uc218\ub85c \uc778\ud55c \uc798\ubabb\ub41c \ubcc0\uacbd\uc744 \ubc29\uc9c0\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. <code>SQL_SAFE_UPDATES<\/code>\uac00 \ud65c\uc131\ud654(\uac12\uc774 1\ub85c \uc124\uc815)\ub418\uc5b4 \uc788\uc73c\uba74, <code>UPDATE<\/code>\ub098 <code>DELETE<\/code> \uba85\ub839\uc744 \uc0ac\uc6a9\ud560 \ub54c <code>WHERE<\/code> \uc808 \uc5c6\uc774 \uc774\ub7ec\ud55c \uba85\ub839\uc744 \uc2e4\ud589\ud558\ub294 \uac83\uc774 \ucc28\ub2e8\ub429\ub2c8\ub2e4. \uc989, \uc0ac\uc6a9\uc790\uac00 \ud2b9\uc815 \uc870\uac74 \uc5c6\uc774 \uc804\uccb4 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\ub97c \ubcc0\uacbd\ud558\uac70\ub098 \uc0ad\uc81c\ud558\ub294 \uac83\uc744 \ubc29\uc9c0\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p><code>SQL_SAFE_UPDATES<\/code>\uc758 \uae30\ubcf8\uac12\uc740 <strong>0<\/strong>\uc785\ub2c8\ub2e4. \uc774\ub294 \uae30\ubcf8\uc801\uc73c\ub85c <code>SQL_SAFE_UPDATES<\/code>\uac00 \ube44\ud65c\uc131\ud654\ub418\uc5b4 \uc788\uc74c\uc744 \uc758\ubbf8\ud558\uba70, \uc0ac\uc6a9\uc790\uac00 \uba85\uc2dc\uc801\uc73c\ub85c \uc870\uac74 \uc5c6\uc774 <code>UPDATE<\/code>\ub098 <code>DELETE<\/code> \uba85\ub839\uc744 \uc2e4\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \ubcf4\uc548\uacfc \uc2e4\uc218 \ubc29\uc9c0\ub97c \uc704\ud574 \uac1c\ubc1c \ud658\uacbd\uc774\ub098 \ud504\ub85c\ub355\uc158 \ud658\uacbd\uc5d0\uc11c \uc774 \uc635\uc158\uc744 1\ub85c \uc124\uc815\ud558\uc5ec \ud65c\uc131\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud65c\uc131\ud654\ub418\uba74, <code>WHERE<\/code> \uc808\uc744 \uc0ac\uc6a9\ud558\uc5ec \uba85\uc2dc\uc801\uc73c\ub85c \uc5b4\ub5a4 \ub808\ucf54\ub4dc\ub97c \uc5c5\ub370\uc774\ud2b8\ud558\uac70\ub098 \uc0ad\uc81c\ud560\uc9c0 \uc9c0\uc815\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>MySQL Workbench \uac19\uc740 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud560 \uacbd\uc6b0, \uc774 \uc124\uc815\uc740 \uae30\ubcf8\uc801\uc73c\ub85c \ud65c\uc131\ud654\ub418\uc5b4 \uc788\uc744 \uc218 \uc788\uc73c\ubbc0\ub85c, <code>UPDATE<\/code>\ub098 <code>DELETE<\/code> \uba85\ub839\uc744 \uc2e4\ud589\ud558\uae30 \uc804\uc5d0 \ud655\uc778\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4. \uc124\uc815\uc744 \ubcc0\uacbd\ud558\ub824\uba74 \ub2e4\uc74c SQL \uba85\ub839\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#0F111A\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" data-code=\"SET SQL_SAFE_UPDATES = 0; -- \ube44\ud65c\uc131\ud654 \nSET SQL_SAFE_UPDATES = 1; -- \ud65c\uc131\ud654\" style=\"color:#babed8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki material-theme-ocean\" style=\"background-color: #0F111A\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F78C6C\">SET<\/span><span style=\"color: #BABED8\"> SQL_SAFE_UPDATES <\/span><span style=\"color: #89DDFF\">=<\/span><span style=\"color: #BABED8\"> <\/span><span style=\"color: #F78C6C\">0<\/span><span style=\"color: #BABED8\">; <\/span><span style=\"color: #464B5D; font-style: italic\">-- \ube44\ud65c\uc131\ud654 <\/span><\/span>\n<span class=\"line\"><span style=\"color: #F78C6C\">SET<\/span><span style=\"color: #BABED8\"> SQL_SAFE_UPDATES <\/span><span style=\"color: #89DDFF\">=<\/span><span style=\"color: #BABED8\"> <\/span><span style=\"color: #F78C6C\">1<\/span><span style=\"color: #BABED8\">; <\/span><span style=\"color: #464B5D; font-style: italic\">-- \ud65c\uc131\ud654<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>\uc774 \uc124\uc815\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790\uac00 \uc2e4\uc218\ub85c \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \uc798\ubabb \ubcc0\uacbd\ud558\uac70\ub098 \uc0ad\uc81c\ud558\ub294 \uac83\uc744 \ubc29\uc9c0\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>CREATE TABLE (DDL) \uc758\ubbf8<\/p>\n","protected":false},"author":1,"featured_media":1684,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[1],"tags":[149,117],"_links":{"self":[{"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/posts\/1680"}],"collection":[{"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1680"}],"version-history":[{"count":1,"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/posts\/1680\/revisions"}],"predecessor-version":[{"id":1685,"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/posts\/1680\/revisions\/1685"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/media\/1684"}],"wp:attachment":[{"href":"https:\/\/dohokin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1680"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1680"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}