{"id":20291,"date":"2018-03-20T11:20:00","date_gmt":"2018-03-20T02:20:00","guid":{"rendered":"http:\/\/w3devlabs.net\/wp\/?p=20291"},"modified":"2018-03-17T22:20:26","modified_gmt":"2018-03-17T13:20:26","slug":"mysql-mariadb%ec%97%90%ec%84%9c-%ed%85%8c%ec%9d%b4%eb%b8%94-%ec%bb%ac%eb%9f%bc%ec%9d%98-%ed%81%ac%ea%b8%b0-%eb%b3%80%ea%b2%bd%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"http:\/\/w3devlabs.net\/wp\/?p=20291","title":{"rendered":"MySQL, mariaDB\uc5d0\uc11c \ud14c\uc774\ube14 \uceec\ub7fc\uc758 \ud06c\uae30 \ubcc0\uacbd\ubc29\ubc95"},"content":{"rendered":"<p><b id=\"docs-internal-guid-6a5bd475-341d-6bcd-764d-f7c3e6e87d79\" style=\"line-height: normal; letter-spacing: normal;\"><\/p>\n<p style=\"line-height: 1.38; letter-spacing: normal; margin-top: 0pt; margin-bottom: 3pt;\" dir=\"ltr\"><span style=\"letter-spacing: normal; vertical-align: baseline; white-space: pre-wrap;\"><font style=\"font-size: 26pt;\">MySQL, mariaDB\uc5d0\uc11c \ud14c\uc774\ube14 \uceec\ub7fc\uc758 \ud06c\uae30 \ubcc0\uacbd\ubc29\ubc95<\/font><\/span><\/p>\n<p><br style=\"letter-spacing: normal;\"><br style=\"letter-spacing: normal;\"><\/p>\n<p style=\"line-height: 1.38; letter-spacing: normal; margin-top: 0pt; margin-bottom: 0pt;\" dir=\"ltr\"><span style=\"letter-spacing: normal; vertical-align: baseline; white-space: pre-wrap;\"><font style=\"font-size: 11pt;\">\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc791\uc5c5\uc744 \ud558\ub2e4\ubcf4\uba74 \uc0c8\ub85c \uc791\uc131\ud55c \ud14c\uc774\ube14\uc758 \uceec\ub7fc \ud06c\uae30\uac00 \uc791\uc5b4\uc11c \uc624\ub958\uac00 \ub098\uac70\ub098 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \uc774\ub7f0\uacbd\uc6b0 \uc5b4\ub5bb\uac8c \uceec\ub7fc\uc758 \ud06c\uae30\ub97c \ubcc0\uacbd\ud558\ub294\uc9c0 \uc54c\uc544\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n<p><br style=\"letter-spacing: normal;\"><br style=\"letter-spacing: normal;\"><\/p>\n<p style=\"line-height: 1.38; letter-spacing: normal; margin-top: 0pt; margin-bottom: 0pt;\" dir=\"ltr\"><span style=\"letter-spacing: normal; vertical-align: baseline; white-space: pre-wrap;\"><font style=\"font-size: 11pt;\">alter table \ud14c\uc774\ube14\uba85 modify \uceec\ub7fc\uba85 varchar(\ud06c\uae30);<\/font><\/span><\/p>\n<p><br style=\"letter-spacing: normal;\"><\/p>\n<p style=\"line-height: 1.38; letter-spacing: normal; margin-top: 0pt; margin-bottom: 0pt;\" dir=\"ltr\"><span style=\"letter-spacing: normal; vertical-align: baseline; white-space: pre-wrap;\"><br class=\"kix-line-break\" style=\"letter-spacing: normal;\"><\/span><span style=\"letter-spacing: normal; vertical-align: baseline; white-space: pre-wrap;\"><font style=\"font-size: 11pt;\">alter table news_list modify link VARCHAR(300) ;<\/font><\/span><\/p>\n<p><br style=\"letter-spacing: normal;\"><\/p>\n<p style=\"line-height: 1.38; letter-spacing: normal; margin-top: 0pt; margin-bottom: 0pt;\" dir=\"ltr\"><span style=\"letter-spacing: normal; vertical-align: baseline; white-space: pre-wrap;\"><img loading=\"lazy\" decoding=\"async\" width=\"497\" height=\"200\" style=\"border: currentcolor; border-image: none; letter-spacing: normal; max-width: none; transform: rotate(0rad); -webkit-transform: rotate(0.00rad);\" src=\"https:\/\/lh6.googleusercontent.com\/13d4k74tzd0mjeacBITp-0OWuQY4uEzwK9xdbpprSOkLBK4YDL-WLVdljk8NeBCRJq_qvB_RddHtTQHozyZ6qtMqvoTmxAQnihXe0r1EvTHauCc7sDGJyht83Uh-UMBceSzcbAe9\"><\/span><\/p>\n<p><br style=\"letter-spacing: normal;\"><\/p>\n<p style=\"line-height: 1.38; letter-spacing: normal; margin-top: 0pt; margin-bottom: 0pt;\" dir=\"ltr\"><span style=\"letter-spacing: normal; vertical-align: baseline; white-space: pre-wrap;\"><font style=\"font-size: 11pt;\">\uc704\uc640 \uac19\uc774 \uc815\uc0c1\uc801\uc73c\ub85c \uceec\ub7fc\uc758 \ud06c\uae30\uac00 300\uc73c\ub85c \ubcc0\uacbd\ub41c\uac83\uc744 \ud655\uc778\ud560\uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n<p><br style=\"letter-spacing: normal;\"><\/p>\n<p style=\"line-height: 1.38; letter-spacing: normal; margin-top: 0pt; margin-bottom: 0pt;\" dir=\"ltr\"><span style=\"letter-spacing: normal; vertical-align: baseline; white-space: pre-wrap;\"><font style=\"font-size: 11pt;\">\ud14c\uc774\ube14\uc5d0\uc11c \uceec\ub7fc\uc758 \ud06c\uae30\ub97c \uc798\ubabb\uacc4\uc0b0\ud55c\uacbd\uc6b0 \uc704\uc640\uac19\uc740 \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud574\uc11c \ubcc0\uacbd\ud558\uba74 \ub429\ub2c8\ub2e4.<\/font><\/span><\/p>\n<p><br style=\"letter-spacing: normal;\"><br style=\"letter-spacing: normal;\"><\/p>\n<p style=\"line-height: 1.38; letter-spacing: normal; margin-top: 0pt; margin-bottom: 0pt;\" dir=\"ltr\"><span style=\"letter-spacing: normal; vertical-align: baseline; white-space: pre-wrap;\"><font style=\"font-size: 11pt;\">\uc624\ub298\uc740 \ud14c\uc774\ube14\uc5d0\uc11c \uceec\ub7fc\uc758 \ud06c\uae30\ub97c \uc798\ubabb \ub9cc\ub4e4\uc5b4\uc9c4 \uacbd\uc6b0 \ud574\ub2f9 \uceec\ub7fc\uc758 \ud06c\uae30\ub97c \ubcc0\uacbd\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\uc558\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n<p><br style=\"letter-spacing: normal;\"><br style=\"letter-spacing: normal;\"><\/b><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL, mariaDB\uc5d0\uc11c \ud14c\uc774\ube14 \uceec\ub7fc\uc758 \ud06c\uae30 \ubcc0\uacbd\ubc29\ubc95 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc791\uc5c5\uc744 \ud558\ub2e4\ubcf4\uba74 \uc0c8\ub85c \uc791\uc131\ud55c \ud14c\uc774\ube14\uc758 \uceec\ub7fc \ud06c\uae30\uac00 \uc791\uc5b4\uc11c \uc624\ub958\uac00 \ub098\uac70\ub098 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \uc774\ub7f0\uacbd\uc6b0 \uc5b4\ub5bb\uac8c \uceec\ub7fc\uc758 \ud06c\uae30\ub97c \ubcc0\uacbd\ud558\ub294\uc9c0 \uc54c\uc544\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. alter table \ud14c\uc774\ube14\uba85 modify \uceec\ub7fc\uba85 varchar(\ud06c\uae30); alter table news_list modify link VARCHAR(300) ; \uc704\uc640 \uac19\uc774 \uc815\uc0c1\uc801\uc73c\ub85c \uceec\ub7fc\uc758 \ud06c\uae30\uac00 300\uc73c\ub85c \ubcc0\uacbd\ub41c\uac83\uc744 \ud655\uc778\ud560\uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud14c\uc774\ube14\uc5d0\uc11c \uceec\ub7fc\uc758 \ud06c\uae30\ub97c \uc798\ubabb\uacc4\uc0b0\ud55c\uacbd\uc6b0 \uc704\uc640\uac19\uc740 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/w3devlabs.net\/wp\/?p=20291\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;MySQL, mariaDB\uc5d0\uc11c \ud14c\uc774\ube14 \uceec\ub7fc\uc758 \ud06c\uae30 \ubcc0\uacbd\ubc29\ubc95&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[18240],"tags":[18565,5417,24216],"class_list":["post-20291","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mariadb","tag-mysql","tag-24216","entry"],"_links":{"self":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/20291","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=20291"}],"version-history":[{"count":1,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/20291\/revisions"}],"predecessor-version":[{"id":20292,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/20291\/revisions\/20292"}],"wp:attachment":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=20291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=20291"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=20291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}