{"id":1453,"date":"2026-05-13T23:11:12","date_gmt":"2026-05-13T14:11:12","guid":{"rendered":"http:\/\/www.igoni.kr\/?p=1453"},"modified":"2026-05-13T23:11:12","modified_gmt":"2026-05-13T14:11:12","slug":"mysql-%eb%8d%b0%ec%9d%b4%ed%84%b0%ea%b0%92-%eb%b3%80%ea%b2%bd%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/www.igoni.kr\/?p=1453","title":{"rendered":"mysql \ub370\uc774\ud130\uac12 \ubcc0\uacbd\ud558\uae30"},"content":{"rendered":"<p>\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8\uc785\ub2c8\ub2e4.<\/p>\n<p id=\"bkmrk-mysql-%EC%A0%84%EC%B2%B4-%EC%BB%AC%EB%9F%BC%EC%9D%98-%EB%8D%B0%EC%9D%B4%ED%84%B0-%EB%B3%80%EA%B2%BD%ED%95%98\">mysql \ud2b9\uc815 \uceec\ub7fc\uc758 \ub370\uc774\ud130 \ubcc0\uacbd\uc774 \ud544\uc694\ud560\ub54c\uac00 \uc788\uc5c8\uc5b4\uc694. \uadf8\ub7f4\ub54c \uc544\ub798 \ub0b4\uc6a9\uc73c\ub85c \ubcc0\ud658 \uc791\uc5c5\uc744 \uc9c4\ud589\ud588\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\" border=\"1\">\n<colgroup>\n<col style=\"width: 99.881%;\" \/><\/colgroup>\n<tbody>\n<tr>\n<td><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1455\" src=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/0e44bba4-a1a1-457f-bd7c-143821e39ef0.png\" alt=\"\" width=\"1032\" height=\"576\" srcset=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/0e44bba4-a1a1-457f-bd7c-143821e39ef0.png 1032w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/0e44bba4-a1a1-457f-bd7c-143821e39ef0-300x167.png 300w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/0e44bba4-a1a1-457f-bd7c-143821e39ef0-1024x572.png 1024w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/0e44bba4-a1a1-457f-bd7c-143821e39ef0-768x429.png 768w\" sizes=\"auto, (max-width: 1032px) 100vw, 1032px\" \/><\/td>\n<\/tr>\n<tr>\n<td>perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p id=\"bkmrk-%ED%85%8C%EC%9D%B4%EB%B8%94%EB%AA%85-%3A-test_table%EC%97%85%EB%8D%B0%EC%9D%B4\">\ud14c\uc774\ube14\uba85 : test_table<br \/>\n\uc5c5\ub370\uc774\ud2b8 \ub300\uc0c1 \uceec\ub7fc : name_cols<br \/>\n\uc6d0\ub798 \ubb38\uc790 : linux<br \/>\n\ubc14\uafc0\ubb38\uc790 : windows<\/p>\n<pre id=\"bkmrk-mysql%3E-update-test_t\"><code class=\"language-SQL\">MYSQL&gt; update test_table set name_cols=replace(name_cols,'linux','windows');<\/code><\/pre>\n<div id=\"bkmrk-\" class=\"wikimodel-emptyline\"><\/div>\n<p id=\"bkmrk-reference\"><em>reference<\/em><\/p>\n<ul id=\"bkmrk-http%3A%2F%2Fjobdahan.net%2F\">\n<li><em><span class=\"wikiexternallink\"><a href=\"http:\/\/jobdahan.net\/mysql\/1394848\">http:\/\/jobdahan.net\/mysql\/1394848<\/a><\/span><\/em><\/li>\n<li><div class=\"vlp-link-container vlp-layout-spotlight\"><a href=\"http:\/\/wiki.igoni.kr\/books\/4-dbms\/page\/mysql\" class=\"vlp-link\" title=\"mysql \ub370\uc774\ud130\uac12 \ubcc0\uacbd\ud558\uae30 | \uc774\uace4\uc544\uc774\" rel=\"nofollow\" target=\"_blank\"><\/a><div class=\"vlp-layout-zone-side\"><div class=\"vlp-block-4 vlp-link-image\"><\/div><\/div><div class=\"vlp-layout-zone-main\"><div class=\"vlp-block-0 vlp-link-title\">mysql \ub370\uc774\ud130\uac12 \ubcc0\uacbd\ud558\uae30 | \uc774\uace4\uc544\uc774<\/div><div class=\"vlp-block-1 vlp-link-summary\">\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8\uc785\ub2c8\ub2e4.\u00a0<br \/>\r\nmysql \ud2b9\uc815 \uceec\ub7fc\uc758 \ub370\uc774\ud130 \ubcc0\uacbd\uc774 \ud544\uc694\ud560\ub54c\uac00 \uc788\uc5c8\uc5b4\uc694. \uadf8\ub7f4\ub54c \uc544\ub798 \ub0b4\uc6a9\uc73c\ub85c...<\/div><div class=\"vlp-block-2 vlp-link-button\">\ub354 \ubcf4\uae30<\/div><div class=\"vlp-block-3 vlp-link-url\">wiki.igoni.kr<\/div><\/div><\/div><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8\uc785\ub2c8\ub2e4. mysql \ud2b9\uc815 \uceec\ub7fc\uc758 \ub370\uc774\ud130 \ubcc0\uacbd\uc774 \ud544\uc694\ud560\ub54c\uac00 \uc788\uc5c8\uc5b4\uc694. \uadf8\ub7f4\ub54c \uc544\ub798 \ub0b4\uc6a9\uc73c\ub85c \ubcc0\ud658 \uc791\uc5c5\uc744 \uc9c4\ud589\ud588\uc5c8\uc2b5\ub2c8\ub2e4. perplexity\uc5d0\uc11c&hellip;<\/p>\n","protected":false},"author":1,"featured_media":1455,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[381],"tags":[383],"class_list":["post-1453","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysqlmariadb","tag-mysql"],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1453","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1453"}],"version-history":[{"count":1,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1453\/revisions"}],"predecessor-version":[{"id":1457,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1453\/revisions\/1457"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/media\/1455"}],"wp:attachment":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1453"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1453"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}