{"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\"><colgroup> <col style=\"width: 99.881%\"><\/colgroup>\n<tbody>\n<tr>\n<td><figure id=\"attachment_mmd_1455\" class=\"wp-block-image alignnone\"><img decoding=\"async\" width=\"1032\" height=\"576\" src=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/0e44bba4-a1a1-457f-bd7c-143821e39ef0.png\" class=\"attachment-full size-full\" alt=\"\" loading=\"lazy\" align=\"none\" \/><\/figure><\/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\n\uc5c5\ub370\uc774\ud2b8 \ub300\uc0c1 \uceec\ub7fc : name_cols\n\uc6d0\ub798 \ubb38\uc790 : linux\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,&#039;linux&#039;,&#039;windows&#039;);<\/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\n<li><em><span class=\"wikiexternallink\"><a href=\"http:\/\/jobdahan.net\/mysql\/1394848\">http:\/\/jobdahan.net\/mysql\/1394848<\/a><\/span><\/em><\/li>\n\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>","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>","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":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\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 \uc0dd\uc131\ud55c AI\uc774\ubbf8 \ud14c\uc774\ube14\uba85 : test_table \uc5c5\ub370\uc774\ud2b8 \ub300\uc0c1 \uceec\ub7fc : name_cols \uc6d0\ub798 \ubb38\uc790 : linux \ubc14\uafc0\ubb38\uc790 : windows MYSQL&gt; update test_table set name_cols=replace(name_cols,&#039;linux&#039;,&#039;windows&#039;); reference http:\/\/jobdahan.net\/mysql\/1394848\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"artop0420\"\/>\n\t<link rel=\"canonical\" href=\"http:\/\/www.igoni.kr\/?p=1453\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"ko_KR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"\uc774\uace4\uc544\uc774 - \uc798\ub098\uac00\ub294 \uc804\uc0b0\uc7c1\uc774\uc758 \ube14\ub85c\uadf8\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"mysql \ub370\uc774\ud130\uac12 \ubcc0\uacbd\ud558\uae30 - \uc774\uace4\uc544\uc774\" \/>\n\t\t<meta property=\"og:description\" content=\"\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 \uc0dd\uc131\ud55c AI\uc774\ubbf8 \ud14c\uc774\ube14\uba85 : test_table \uc5c5\ub370\uc774\ud2b8 \ub300\uc0c1 \uceec\ub7fc : name_cols \uc6d0\ub798 \ubb38\uc790 : linux \ubc14\uafc0\ubb38\uc790 : windows MYSQL&gt; update test_table set name_cols=replace(name_cols,&#039;linux&#039;,&#039;windows&#039;); reference http:\/\/jobdahan.net\/mysql\/1394848\" \/>\n\t\t<meta property=\"og:url\" content=\"http:\/\/www.igoni.kr\/?p=1453\" \/>\n\t\t<meta property=\"og:image\" content=\"http:\/\/word.igoni.kr\/wp-content\/uploads\/2026\/01\/cropped-j3fi6eistvc5ixa6lvm3ra-1.jpg\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-05-13T14:11:12+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-05-13T14:11:12+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"mysql \ub370\uc774\ud130\uac12 \ubcc0\uacbd\ud558\uae30 - \uc774\uace4\uc544\uc774\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\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 \uc0dd\uc131\ud55c AI\uc774\ubbf8 \ud14c\uc774\ube14\uba85 : test_table \uc5c5\ub370\uc774\ud2b8 \ub300\uc0c1 \uceec\ub7fc : name_cols \uc6d0\ub798 \ubb38\uc790 : linux \ubc14\uafc0\ubb38\uc790 : windows MYSQL&gt; update test_table set name_cols=replace(name_cols,&#039;linux&#039;,&#039;windows&#039;); reference http:\/\/jobdahan.net\/mysql\/1394848\" \/>\n\t\t<meta name=\"twitter:image\" content=\"http:\/\/word.igoni.kr\/wp-content\/uploads\/2026\/01\/cropped-j3fi6eistvc5ixa6lvm3ra-1.jpg\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1453#blogposting\",\"name\":\"mysql \\ub370\\uc774\\ud130\\uac12 \\ubcc0\\uacbd\\ud558\\uae30 - \\uc774\\uace4\\uc544\\uc774\",\"headline\":\"mysql \\ub370\\uc774\\ud130\\uac12 \\ubcc0\\uacbd\\ud558\\uae30\",\"author\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?author=1#author\"},\"publisher\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"http:\\\/\\\/www.igoni.kr\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/0e44bba4-a1a1-457f-bd7c-143821e39ef0.png\",\"width\":1032,\"height\":576},\"datePublished\":\"2026-05-13T23:11:12+09:00\",\"dateModified\":\"2026-05-13T23:11:12+09:00\",\"inLanguage\":\"ko-KR\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1453#webpage\"},\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1453#webpage\"},\"articleSection\":\"Mysql&amp;MariaDB, mysql\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1453#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.igoni.kr\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=379#listItem\",\"name\":\"4. DBMS \\uc815\\ubcf4 \\uae30\\ub85d\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=379#listItem\",\"position\":2,\"name\":\"4. DBMS \\uc815\\ubcf4 \\uae30\\ub85d\",\"item\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=379\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=381#listItem\",\"name\":\"Mysql&amp;MariaDB\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=381#listItem\",\"position\":3,\"name\":\"Mysql&amp;MariaDB\",\"item\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=381\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1453#listItem\",\"name\":\"mysql \\ub370\\uc774\\ud130\\uac12 \\ubcc0\\uacbd\\ud558\\uae30\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=379#listItem\",\"name\":\"4. DBMS \\uc815\\ubcf4 \\uae30\\ub85d\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1453#listItem\",\"position\":4,\"name\":\"mysql \\ub370\\uc774\\ud130\\uac12 \\ubcc0\\uacbd\\ud558\\uae30\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=381#listItem\",\"name\":\"Mysql&amp;MariaDB\"}}]},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#person\",\"name\":\"artop0420\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1453#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6ed969bb042731f83571e940de11778b3d6af729b07d53ffb1c9cf224e32620f?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"artop0420\"}},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?author=1#author\",\"url\":\"http:\\\/\\\/www.igoni.kr\\\/?author=1\",\"name\":\"artop0420\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1453#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6ed969bb042731f83571e940de11778b3d6af729b07d53ffb1c9cf224e32620f?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"artop0420\"}},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1453#webpage\",\"url\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1453\",\"name\":\"mysql \\ub370\\uc774\\ud130\\uac12 \\ubcc0\\uacbd\\ud558\\uae30 - \\uc774\\uace4\\uc544\\uc774\",\"description\":\"\\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 \\uc0dd\\uc131\\ud55c AI\\uc774\\ubbf8 \\ud14c\\uc774\\ube14\\uba85 : test_table \\uc5c5\\ub370\\uc774\\ud2b8 \\ub300\\uc0c1 \\uceec\\ub7fc : name_cols \\uc6d0\\ub798 \\ubb38\\uc790 : linux \\ubc14\\uafc0\\ubb38\\uc790 : windows MYSQL> update test_table set name_cols=replace(name_cols,'linux','windows'); reference http:\\\/\\\/jobdahan.net\\\/mysql\\\/1394848\",\"inLanguage\":\"ko-KR\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#website\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1453#breadcrumblist\"},\"author\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?author=1#author\"},\"creator\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?author=1#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"http:\\\/\\\/www.igoni.kr\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/0e44bba4-a1a1-457f-bd7c-143821e39ef0.png\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1453\\\/#mainImage\",\"width\":1032,\"height\":576},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1453#mainImage\"},\"datePublished\":\"2026-05-13T23:11:12+09:00\",\"dateModified\":\"2026-05-13T23:11:12+09:00\"},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#website\",\"url\":\"http:\\\/\\\/www.igoni.kr\\\/\",\"name\":\"\\uc774\\uace4\\uc544\\uc774\",\"description\":\"\\uc798\\ub098\\uac00\\ub294 \\uc804\\uc0b0\\uc7c1\\uc774\\uc758 \\ube14\\ub85c\\uadf8\",\"inLanguage\":\"ko-KR\",\"publisher\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"mysql \ub370\uc774\ud130\uac12 \ubcc0\uacbd\ud558\uae30 - \uc774\uace4\uc544\uc774","description":"\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 \uc0dd\uc131\ud55c AI\uc774\ubbf8 \ud14c\uc774\ube14\uba85 : test_table \uc5c5\ub370\uc774\ud2b8 \ub300\uc0c1 \uceec\ub7fc : name_cols \uc6d0\ub798 \ubb38\uc790 : linux \ubc14\uafc0\ubb38\uc790 : windows MYSQL> update test_table set name_cols=replace(name_cols,'linux','windows'); reference http:\/\/jobdahan.net\/mysql\/1394848","canonical_url":"http:\/\/www.igoni.kr\/?p=1453","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"http:\/\/www.igoni.kr\/?p=1453#blogposting","name":"mysql \ub370\uc774\ud130\uac12 \ubcc0\uacbd\ud558\uae30 - \uc774\uace4\uc544\uc774","headline":"mysql \ub370\uc774\ud130\uac12 \ubcc0\uacbd\ud558\uae30","author":{"@id":"http:\/\/www.igoni.kr\/?author=1#author"},"publisher":{"@id":"http:\/\/www.igoni.kr\/#person"},"image":{"@type":"ImageObject","url":"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/0e44bba4-a1a1-457f-bd7c-143821e39ef0.png","width":1032,"height":576},"datePublished":"2026-05-13T23:11:12+09:00","dateModified":"2026-05-13T23:11:12+09:00","inLanguage":"ko-KR","mainEntityOfPage":{"@id":"http:\/\/www.igoni.kr\/?p=1453#webpage"},"isPartOf":{"@id":"http:\/\/www.igoni.kr\/?p=1453#webpage"},"articleSection":"Mysql&amp;MariaDB, mysql"},{"@type":"BreadcrumbList","@id":"http:\/\/www.igoni.kr\/?p=1453#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"http:\/\/www.igoni.kr#listItem","position":1,"name":"Home","item":"http:\/\/www.igoni.kr","nextItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=379#listItem","name":"4. DBMS \uc815\ubcf4 \uae30\ub85d"}},{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=379#listItem","position":2,"name":"4. DBMS \uc815\ubcf4 \uae30\ub85d","item":"http:\/\/www.igoni.kr\/?cat=379","nextItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=381#listItem","name":"Mysql&amp;MariaDB"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr#listItem","name":"Home"}},{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=381#listItem","position":3,"name":"Mysql&amp;MariaDB","item":"http:\/\/www.igoni.kr\/?cat=381","nextItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?p=1453#listItem","name":"mysql \ub370\uc774\ud130\uac12 \ubcc0\uacbd\ud558\uae30"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=379#listItem","name":"4. DBMS \uc815\ubcf4 \uae30\ub85d"}},{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?p=1453#listItem","position":4,"name":"mysql \ub370\uc774\ud130\uac12 \ubcc0\uacbd\ud558\uae30","previousItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=381#listItem","name":"Mysql&amp;MariaDB"}}]},{"@type":"Person","@id":"http:\/\/www.igoni.kr\/#person","name":"artop0420","image":{"@type":"ImageObject","@id":"http:\/\/www.igoni.kr\/?p=1453#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/6ed969bb042731f83571e940de11778b3d6af729b07d53ffb1c9cf224e32620f?s=96&d=mm&r=g","width":96,"height":96,"caption":"artop0420"}},{"@type":"Person","@id":"http:\/\/www.igoni.kr\/?author=1#author","url":"http:\/\/www.igoni.kr\/?author=1","name":"artop0420","image":{"@type":"ImageObject","@id":"http:\/\/www.igoni.kr\/?p=1453#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/6ed969bb042731f83571e940de11778b3d6af729b07d53ffb1c9cf224e32620f?s=96&d=mm&r=g","width":96,"height":96,"caption":"artop0420"}},{"@type":"WebPage","@id":"http:\/\/www.igoni.kr\/?p=1453#webpage","url":"http:\/\/www.igoni.kr\/?p=1453","name":"mysql \ub370\uc774\ud130\uac12 \ubcc0\uacbd\ud558\uae30 - \uc774\uace4\uc544\uc774","description":"\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 \uc0dd\uc131\ud55c AI\uc774\ubbf8 \ud14c\uc774\ube14\uba85 : test_table \uc5c5\ub370\uc774\ud2b8 \ub300\uc0c1 \uceec\ub7fc : name_cols \uc6d0\ub798 \ubb38\uc790 : linux \ubc14\uafc0\ubb38\uc790 : windows MYSQL> update test_table set name_cols=replace(name_cols,'linux','windows'); reference http:\/\/jobdahan.net\/mysql\/1394848","inLanguage":"ko-KR","isPartOf":{"@id":"http:\/\/www.igoni.kr\/#website"},"breadcrumb":{"@id":"http:\/\/www.igoni.kr\/?p=1453#breadcrumblist"},"author":{"@id":"http:\/\/www.igoni.kr\/?author=1#author"},"creator":{"@id":"http:\/\/www.igoni.kr\/?author=1#author"},"image":{"@type":"ImageObject","url":"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/0e44bba4-a1a1-457f-bd7c-143821e39ef0.png","@id":"http:\/\/www.igoni.kr\/?p=1453\/#mainImage","width":1032,"height":576},"primaryImageOfPage":{"@id":"http:\/\/www.igoni.kr\/?p=1453#mainImage"},"datePublished":"2026-05-13T23:11:12+09:00","dateModified":"2026-05-13T23:11:12+09:00"},{"@type":"WebSite","@id":"http:\/\/www.igoni.kr\/#website","url":"http:\/\/www.igoni.kr\/","name":"\uc774\uace4\uc544\uc774","description":"\uc798\ub098\uac00\ub294 \uc804\uc0b0\uc7c1\uc774\uc758 \ube14\ub85c\uadf8","inLanguage":"ko-KR","publisher":{"@id":"http:\/\/www.igoni.kr\/#person"}}]},"og:locale":"ko_KR","og:site_name":"\uc774\uace4\uc544\uc774 - \uc798\ub098\uac00\ub294 \uc804\uc0b0\uc7c1\uc774\uc758 \ube14\ub85c\uadf8","og:type":"article","og:title":"mysql \ub370\uc774\ud130\uac12 \ubcc0\uacbd\ud558\uae30 - \uc774\uace4\uc544\uc774","og:description":"\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 \uc0dd\uc131\ud55c AI\uc774\ubbf8 \ud14c\uc774\ube14\uba85 : test_table \uc5c5\ub370\uc774\ud2b8 \ub300\uc0c1 \uceec\ub7fc : name_cols \uc6d0\ub798 \ubb38\uc790 : linux \ubc14\uafc0\ubb38\uc790 : windows MYSQL&gt; update test_table set name_cols=replace(name_cols,'linux','windows'); reference http:\/\/jobdahan.net\/mysql\/1394848","og:url":"http:\/\/www.igoni.kr\/?p=1453","og:image":"http:\/\/word.igoni.kr\/wp-content\/uploads\/2026\/01\/cropped-j3fi6eistvc5ixa6lvm3ra-1.jpg","article:published_time":"2026-05-13T14:11:12+00:00","article:modified_time":"2026-05-13T14:11:12+00:00","twitter:card":"summary_large_image","twitter:title":"mysql \ub370\uc774\ud130\uac12 \ubcc0\uacbd\ud558\uae30 - \uc774\uace4\uc544\uc774","twitter:description":"\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 \uc0dd\uc131\ud55c AI\uc774\ubbf8 \ud14c\uc774\ube14\uba85 : test_table \uc5c5\ub370\uc774\ud2b8 \ub300\uc0c1 \uceec\ub7fc : name_cols \uc6d0\ub798 \ubb38\uc790 : linux \ubc14\uafc0\ubb38\uc790 : windows MYSQL&gt; update test_table set name_cols=replace(name_cols,'linux','windows'); reference http:\/\/jobdahan.net\/mysql\/1394848","twitter:image":"http:\/\/word.igoni.kr\/wp-content\/uploads\/2026\/01\/cropped-j3fi6eistvc5ixa6lvm3ra-1.jpg"},"aioseo_meta_data":{"post_id":"1453","title":null,"description":null,"keywords":null,"keyphrases":{"focus":[],"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"schemas":[],"titles":[],"descriptions":[],"socialPosts":{"email":[],"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2026-05-13 14:11:12","updated":"2026-08-07 15:16:39","seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.igoni.kr\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.igoni.kr\/?cat=379\" title=\"4. DBMS \uc815\ubcf4 \uae30\ub85d\">4. DBMS \uc815\ubcf4 \uae30\ub85d<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.igoni.kr\/?cat=381\" title=\"Mysql&amp;MariaDB\">Mysql&amp;MariaDB<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tmysql \ub370\uc774\ud130\uac12 \ubcc0\uacbd\ud558\uae30\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"http:\/\/www.igoni.kr"},{"label":"4. DBMS \uc815\ubcf4 \uae30\ub85d","link":"http:\/\/www.igoni.kr\/?cat=379"},{"label":"Mysql&amp;MariaDB","link":"http:\/\/www.igoni.kr\/?cat=381"},{"label":"mysql \ub370\uc774\ud130\uac12 \ubcc0\uacbd\ud558\uae30","link":"http:\/\/www.igoni.kr\/?p=1453"}],"_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}]}}