{"id":2126,"date":"2023-10-28T14:09:00","date_gmt":"2023-10-28T05:09:00","guid":{"rendered":"https:\/\/www.itchefblog.com\/?p=2126"},"modified":"2023-10-30T03:30:04","modified_gmt":"2023-10-29T18:30:04","slug":"%eb%8f%84%ec%84%9c%eb%a6%ac%eb%b7%b0-%eb%9f%ac%eb%8b%9d-mysql","status":"publish","type":"post","link":"https:\/\/www.itchefblog.com\/?p=2126","title":{"rendered":"[\ub3c4\uc11c\ub9ac\ubdf0] \ub7ec\ub2dd MySQL"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"825\" height=\"1024\" src=\"https:\/\/www.itchefblog.com\/wp-content\/uploads\/2023\/10\/learning_mysql-825x1024.jpg\" alt=\"\" class=\"wp-image-2129\" srcset=\"https:\/\/www.itchefblog.com\/wp-content\/uploads\/2023\/10\/learning_mysql-825x1024.jpg 825w, https:\/\/www.itchefblog.com\/wp-content\/uploads\/2023\/10\/learning_mysql-242x300.jpg 242w, https:\/\/www.itchefblog.com\/wp-content\/uploads\/2023\/10\/learning_mysql-768x953.jpg 768w, https:\/\/www.itchefblog.com\/wp-content\/uploads\/2023\/10\/learning_mysql.jpg 1000w\" sizes=\"(max-width: 825px) 100vw, 825px\" \/><\/figure>\n\n\n\n<p>\uac04\ub9cc\uc5d0 MySQL 8.0 \uae30\ubcf8\uc11c\ub97c \ubcfc \uae30\ud68c\uac00 \uc0dd\uacbc\ub2e4.<br>\ud604\uc7ac \uc8fc\ub825\uc73c\ub85c 5.7\ubc84\uc804\uc744 \uc0ac\uc6a9\uc911\uc778\ub370, \ud574\ub2f9 \ubc84\uc804 \uc774\uc0c1\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \ud2b9\ubcc4\ud55c \uae30\ub2a5\ub4e4\uc744 \ud65c\uc6a9\ud560 \uc77c\uc774 \ubcc4\ub85c \uc5c6\uae30\uc5d0 \uadf8\ub0e5 \uc720\uc9c0\uc911\uc774\uc5c8\ub2e4.<br>\ub2e4\ub9cc \uc0c8\ub85c \uc2dc\uc791\ud558\ub294 \ud504\ub85c\uc81d\ud2b8\uc5d0\uc11c \uae30\uc874 \ubc84\uc804\uc5d0\uc11c\ub294 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uac70\ub098 \ub108 \ud6a8\uc728\uc801\uc73c\ub85c \ucc98\ub9ac\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\ub4e4\uc744 \uc368\ubcf4\uae30 \uc704\ud574 \ub3c4\uc785\ud558\ub824\ub358 \uc911\uc5d0 \uc774 \ucc45\uc758 \uc11c\ud3c9\uc744 \uc9c4\ud589\ud558\uac8c \ub418\uc5b4\uc11c \uacb8\uc0ac\uacb8\uc0ac \uc0ac\uc6a9\ud574\ubcf4\ub824 \ud55c\ub2e4.<br><br>\uc5ec\ub290 \uae30\ubcf8\uc11c\ub4e4\uacfc \ub9c8\ucc2c\uac00\uc9c0\ub85c \uc774 \ucc45\ub3c4 \uae30\ubcf8\uc801\uc778 \uc124\uba85, \uc124\uce58\ubc29\ubc95, \uc0ac\uc6a9\ubc29\ubc95, \ucd94\uac00 \ud301\ub4e4 \uacfc \uac19\uc740 \uad6c\uc131\uc73c\ub85c \uc774\ub8e8\uc5b4\uc838 \uc788\ub2e4.<\/p>\n\n\n\n<p>\uc608\uc804\uc5d0 \ub098\uc628 \ucc45\ub4e4\uc740 \uc8fc\ub85c \ubb3c\ub9ac \uc11c\ubc84\ub098 \ub85c\uceec\uc5d0 \uc124\uce58\ud558\ub294 \uacbd\uc6b0\ub97c \uc124\uba85\ud558\uace0 \uc2e4\uc2b5\uc744 \uc9c4\ud589\ud588\ub294\ub370, \ud655\uc2e4\ud788 \uc694\uc0c8\ub294 \ud074\ub77c\uc6b0\ub4dc \ud658\uacbd\uc774 \ubcf4\ud3b8\ud654 \ub418\ub2e4\ubcf4\ub2c8 \ub9ac\ub205\uc2a4 \ubc30\ud3ec\ud310\ubcc4 \uc124\uce58 \ubfd0 \uc544\ub2c8\ub77c OSX, \ub3c4\ucee4 \ud658\uacbd\uc758 \uc138\ud305 \ubc29\ubc95\uae4c\uc9c0 \ub2e4\ub8e8\uace0 \uc788\uc5b4\uc11c \ub180\ub790\ub2e4. (MySQL \uae30\ubcf8\uc11c\ub97c \uc815\ub9d0 \uc624\ub79c\ub9cc\uc5d0 \ubcf4\ub294&#8230;)<\/p>\n\n\n\n<p>SQL\ubb38\uc758 DDL, DML, DCL\uc5d0 \ub300\ud574 \uc0c1\uc138\ud558\uac8c \uc124\uba85\uc774 \ub418\uc5b4\uc788\uace0, \ud504\ub85c\ub355\uc158 \ud658\uacbd\uc5d0\uc11c \uc720\uc6a9\ud558\uac8c \uc0ac\uc6a9\ub418\ub294 \ud2b8\ub79c\uc81d\uc158 \ud301\ub4e4, \uc5ec\ub7ec \ub300\uccb4 \uc2a4\ud1a0\ub9ac\uc9c0 \uc5d4\uc9c4\ub4e4\uc5d0 \ub300\ud55c \uc124\uba85\uc744 \ubcfc \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p>\uc0ac\uc6a9\uc790 \uad8c\ud55c \uad00\ub9ac\uc5d0 \ub300\ud55c \ubd80\ubd84\ub3c4 50\uc5ec \ud398\uc774\uc9c0\ub97c \ud560\ub2f9\ud558\uc5ec \uc124\uba85\ud558\uace0 \uc788\ub294\ub370, \ub2e8\ub3c5\uc73c\ub85c \uc0ac\uc6a9\ud558\ub294 DB\uac00 \uc544\ub2cc \uc774\uc0c1 \uac01 \uacc4\uc815\uc5d0 \ubd80\uc5ec\ub41c \uad8c\ud55c \uc124\uc815\uc774 \ud06c\ub9ac\ud2f0\uceec\ud55c \ubcf4\uc548 \uc0ac\uace0\ub97c \uc77c\uc73c\ud0ac \uc218 \uc788\uae30\uc5d0 \uc815\ub9d0 \uc8fc\uc758\ud574\uc57c\ud558\ub294 \ubd80\ubd84\uc778\ub370, \uc798 \uc219\uc9c0\ud574\ub450\uba74 \uc0c8\ub85c\uc6b4 \uacc4\uc815\uc744 \uc0dd\uc131\ud558\uace0 \uad8c\ud55c\uc744 \ubd80\uc5ec\ud560 \ub54c \uc880\ub354 \uc548\uc804\ud558\uac8c \uc124\uc815\ud560 \uc218 \uc788\uc744 \uac83 \uac19\ub2e4.<\/p>\n\n\n\n<p>MySQL \uc11c\ubc84\uc758 \uc635\uc158\uc758 \uad6c\uc131\uacfc \uae30\ubcf8\uc801\uc778 \uc138\ud305\uc5d0 \uad00\ud574\uc11c\ub3c4 \ub2e4\ub8e8\uace0 \uc788\uc73c\uba70, DB\uc6b4\uc601 \uc2dc \uac00\uc7a5 \uc911\uc694\ud55c \ubc31\uc5c5\uacfc \ubcf5\uad6c\uc5d0 \ub300\ud55c \uc124\uba85\ub3c4 \ucda9\ubd84\ud788 \uc798 \ub418\uc5b4\uc788\ub2e4. \ub2e4\uc591\ud55c \ubc31\uc5c5\/\ubcf5\uad6c\uc758 \ubc29\ubc95\ub4e4\uacfc \ud234\ub4e4\uc744 \uc124\uba85\ud558\uace0 \uc788\ub2e4.<\/p>\n\n\n\n<p>\uc11c\ubc84\ub97c \uad6c\uc131 \uc2dc \uc11c\ubc84 \uc124\uc815\uc758 \ubaa8\ubc94\uc0ac\ub840\ub97c \uc81c\uacf5\ud558\uace0 \uc788\ub2e4. \ubb3c\ub860 \uc774 \ucc45\uc5d0\uc11c \uc548\ub0b4\ud558\ub294 \uc124\uc815\uc774 \uc815\ub2f5\ub3c4 \uc544\ub2c8\uace0, \uc6b4\uc601\ud558\ub294 \ud658\uacbd\uc774\ub098 \ubaa9\uc801\uc5d0 \ub530\ub77c \ubaa8\ub450\ub97c \ub2e4 \ub9cc\uc871\uc2dc\ud0ac \uc218 \uc788\ub294 \uc808\ub300\uc801\uc778 \uac83\ub3c4 \uc544\ub2c8\uc9c0\ub9cc \uc544\uc9c1 \uc6b4\uc601 \uacbd\ud5d8\uc774 \uc5c6\uac70\ub098 \uc775\uc219\ud558\uc9c0 \uc54a\uc740 \uc2e0\uaddc \uc0ac\uc6a9\uc790\ub4e4\uc5d0\uac8c\ub294 \uc815\ub9d0 \ub3c4\uc6c0\ub418\ub294 \uc139\uc158\uc778 \uac83 \uac19\ub2e4.<\/p>\n\n\n\n<p>\ub610\ud55c \ubc31\uc5c5\uacfc \ubcf5\uad6c\uc640 \ub9c8\ucc2c\uac00\uc9c0\ub85c \uc815\ub9d0 \uc911\uc694\ud55c \ubaa8\ub2c8\ud130\ub9c1\uc5d0 \uad00\ud55c \ub0b4\uc6a9\ub3c4 \ube44\uc911 \uc788\uac8c \ub2e4\ub8e8\uace0 \uc788\ub2e4.<br>\ubaa8\ub2c8\ud130\ub9c1 \ud560 \uac01\uc885 \uc9c0\ud45c\uc5d0 \ub300\ud574 \uc124\uba85\ud558\uace0 \uc788\uc73c\uba70, \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c, \uc0ac\uace0\/\uc9c4\ub2e8\uacfc \uadf8\uc5d0 \ub300\ud55c \uc790\ub8cc \uc218\uc9d1 \ub4f1\uc758 \ub0b4\uc6a9\uc744 \uc54c\uc544\ubcfc \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p>\uace0\uac00\uc6a9\uc131\uacfc \ub85c\ub4dc\ubc38\ub7f0\uc2f1\uc5d0 \uad00\ud55c \ub0b4\uc6a9, \ud074\ub77c\uc6b0\ub4dc \uc0c1\uc5d0\uc11c\uc758 MySQL \uc6b4\uc601 \ub4f1\uc5d0 \ub300\ud55c \ub0b4\uc6a9\ub4f1\ub3c4 \ub2e4\uc591\ud558\uac8c \ub2e4\ub8e8\uace0 \uc788\uc5b4\uc11c \uc804\uccb4\uc801\uc778 \uc124\uce58, \uc6b4\uc601 \ubc0f \uc0ac\uc6a9\uc5d0 \ub300\ud55c \ub0b4\uc6a9\ub4e4\uc744 \ud55c\ubc88\uc5d0 \ubc30\uc6b8 \uc218 \uc788\ub294 \ucc45\uc774\ub2e4.<\/p>\n\n\n\n<p>MySQL\uc744 \uc774\ubbf8 \uc798 \ud65c\uc6a9\ud558\uace0 \uc788\ub358 \uc0ac\uc6a9\uc790\ub4e4\uc77c\uc9c0\ub77c\ub3c4 \uafb8\uc900\ud788 \uacf5\ubd80\ud558\uc9c0 \uc54a\uc558\ub2e4\uba74 \uc54c\uc9c0 \ubabb\ud588\uc744 \uc0c8\ub85c\uc6b4 \ub0b4\uc6a9\ub4e4\uc744 \uc5bb\uc744 \uc218 \uc788\uc744 \uac83\uc774\uace0, \ucc98\uc74c \uacf5\ubd80\ub97c \uc2dc\uc791\ud558\ub824\ub294 \uc785\ubb38\uc790\uc5d0\uac8c\ub294 \ub354 \uc5c6\uc774 \ub3c4\uc6c0\ub418\ub294 \ucc38\uace0\uc11c\uac00 \ub420 \uac83 \uac19\ub2e4.<\/p>\n\n\n\n<p class=\"has-small-font-size\">[<strong>\ud55c\ube5b\ubbf8\ub514\uc5b4\u00a0&lt;\ub098\ub294 \ub9ac\ubdf0\uc5b4\ub2e4> \ud65c\ub3d9\uc744 \uc704\ud574\uc11c \ucc45\uc744 \uc81c\uacf5\ubc1b\uc544 \uc791\uc131\ub41c \uc11c\ud3c9\uc785\ub2c8\ub2e4.<\/strong>]<\/p>\n\n\n\n<p>\ubc14\ub85c\uad6c\ub9e4<br><a href=\"https:\/\/www.yes24.com\/Product\/Goods\/122575671\" data-type=\"URL\" data-id=\"https:\/\/www.yes24.com\/Product\/Goods\/122575671\" target=\"_blank\" rel=\"noreferrer noopener\">\uc608\uc2a424<\/a><br><a href=\"https:\/\/product.kyobobook.co.kr\/detail\/S000209212342\" data-type=\"URL\" data-id=\"https:\/\/product.kyobobook.co.kr\/detail\/S000209212342\" target=\"_blank\" rel=\"noreferrer noopener\">\uad50\ubcf4\ubb38\uace0<\/a><br><a href=\"https:\/\/www.aladin.co.kr\/shop\/wproduct.aspx?ItemId=325056977&amp;start=slayer\" data-type=\"URL\" data-id=\"https:\/\/www.aladin.co.kr\/shop\/wproduct.aspx?ItemId=325056977&amp;start=slayer\" target=\"_blank\" rel=\"noreferrer noopener\">\uc54c\ub77c\ub518<\/a><br><a href=\"https:\/\/book.interpark.com\/product\/BookDisplay.do?_method=detail&amp;sc.prdNo=356802961\" data-type=\"URL\" data-id=\"https:\/\/book.interpark.com\/product\/BookDisplay.do?_method=detail&amp;sc.prdNo=356802961\" target=\"_blank\" rel=\"noreferrer noopener\">\uc778\ud130\ud30c\ud06c<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uac04\ub9cc\uc5d0 MySQL 8.0 \uae30\ubcf8\uc11c\ub97c \ubcfc \uae30\ud68c\uac00 \uc0dd\uacbc\ub2e4.\ud604\uc7ac \uc8fc\ub825\uc73c\ub85c 5.7\ubc84\uc804\uc744 \uc0ac\uc6a9\uc911\uc778\ub370, \ud574\ub2f9 \ubc84\uc804 \uc774\uc0c1\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \ud2b9\ubcc4\ud55c \uae30\ub2a5\ub4e4\uc744 \ud65c\uc6a9\ud560 \uc77c\uc774 \ubcc4\ub85c \uc5c6\uae30\uc5d0 \uadf8\ub0e5 \uc720\uc9c0\uc911\uc774\uc5c8\ub2e4.\ub2e4\ub9cc \uc0c8\ub85c \uc2dc\uc791\ud558\ub294 \ud504\ub85c\uc81d\ud2b8\uc5d0\uc11c \uae30\uc874 \ubc84\uc804\uc5d0\uc11c\ub294 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uac70\ub098 \ub108 \ud6a8\uc728\uc801\uc73c\ub85c \ucc98\ub9ac\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\ub4e4\uc744 \uc368\ubcf4\uae30 \uc704\ud574 \ub3c4\uc785\ud558\ub824\ub358 \uc911\uc5d0 \uc774 \ucc45\uc758 \uc11c\ud3c9\uc744 \uc9c4\ud589\ud558\uac8c \ub418\uc5b4\uc11c \uacb8\uc0ac\uacb8\uc0ac \uc0ac\uc6a9\ud574\ubcf4\ub824 \ud55c\ub2e4. \uc5ec\ub290 \uae30\ubcf8\uc11c\ub4e4\uacfc \ub9c8\ucc2c\uac00\uc9c0\ub85c \uc774 \ucc45\ub3c4 \uae30\ubcf8\uc801\uc778 \uc124\uba85, \uc124\uce58\ubc29\ubc95, &hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[920,921,922,923,924,42,686,763],"_links":{"self":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/2126"}],"collection":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2126"}],"version-history":[{"count":4,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/2126\/revisions"}],"predecessor-version":[{"id":2132,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/2126\/revisions\/2132"}],"wp:attachment":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2126"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2126"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}