{"id":68,"date":"2017-10-16T15:24:43","date_gmt":"2017-10-16T06:24:43","guid":{"rendered":"http:\/\/dev.e-luda.com\/dev-note\/?p=124"},"modified":"2017-10-16T15:24:43","modified_gmt":"2017-10-16T06:24:43","slug":"mysql-%eb%aa%85%eb%a0%b9%ec%96%b4","status":"publish","type":"post","link":"http:\/\/dev.e-luda.com\/dev-note\/?p=68","title":{"rendered":"mysql \uba85\ub839\uc5b4"},"content":{"rendered":"<ul>\n<li>\ubc84\uc804 \ud655\uc778 :\n<ul>\n<li>os command : mysql &#8211;version<\/li>\n<li>sql\ub85c \ud655\uc778 : SELECT VERSION()<\/li>\n<\/ul>\n<\/li>\n<li>Database \uc0dd\uc131, \uc0ad\uc81c\n<ul>\n<li>\uc0dd\uc131 : create database &lt;database name&gt;;\n<ul>\n<li>\ubb38\uc790\uc5f4 encoding \uc9c0\uc815: create database &lt;database name&gt; default charset utf8;<\/li>\n<\/ul>\n<\/li>\n<li>\uc0ad\uc81c: drop database &lt;database name&gt;;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\ubc84\uc804 \ud655\uc778 : os command : mysql &#8211;version sql\ub85c \ud655\uc778 : SELECT VERSION() Database \uc0dd\uc131, \uc0ad\uc81c \uc0dd\uc131 : create database &lt;database name&gt;; \ubb38\uc790\uc5f4 encoding \uc9c0\uc815: create database &lt;database name&gt; default charset utf8; \uc0ad\uc81c: drop database &lt;database name&gt;;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-68","post","type-post","status-publish","format-standard","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>mysql \uba85\ub839\uc5b4 - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/dev.e-luda.com\/dev-note\/?p=68\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"mysql \uba85\ub839\uc5b4 - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8\" \/>\n<meta property=\"og:description\" content=\"\ubc84\uc804 \ud655\uc778 : os command : mysql &#8211;version sql\ub85c \ud655\uc778 : SELECT VERSION() Database \uc0dd\uc131, \uc0ad\uc81c \uc0dd\uc131 : create database &lt;database name&gt;; \ubb38\uc790\uc5f4 encoding \uc9c0\uc815: create database &lt;database name&gt; default charset utf8; \uc0ad\uc81c: drop database &lt;database name&gt;;\" \/>\n<meta property=\"og:url\" content=\"http:\/\/dev.e-luda.com\/dev-note\/?p=68\" \/>\n<meta property=\"og:site_name\" content=\"\ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8\" \/>\n<meta property=\"article:published_time\" content=\"2017-10-16T06:24:43+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"wizardlee\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/#website\",\"url\":\"http:\/\/dev.e-luda.com\/dev-note\/\",\"name\":\"\ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8\",\"description\":\"\ub2e4\ub978 \uc6cc\ub4dc\ud504\ub808\uc2a4 \uc0ac\uc774\ud2b8\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/dev.e-luda.com\/dev-note\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/?p=68#webpage\",\"url\":\"http:\/\/dev.e-luda.com\/dev-note\/?p=68\",\"name\":\"mysql \uba85\ub839\uc5b4 - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8\",\"isPartOf\":{\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/#website\"},\"datePublished\":\"2017-10-16T06:24:43+00:00\",\"dateModified\":\"2017-10-16T06:24:43+00:00\",\"author\":{\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/#\/schema\/person\/7e381f3b46b7824adbe15ff43b53c42c\"},\"breadcrumb\":{\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/?p=68#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/dev.e-luda.com\/dev-note\/?p=68\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/?p=68#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/dev.e-luda.com\/dev-note\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"mysql \uba85\ub839\uc5b4\"}]},{\"@type\":\"Person\",\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/#\/schema\/person\/7e381f3b46b7824adbe15ff43b53c42c\",\"name\":\"wizardlee\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/#personlogo\",\"inLanguage\":\"ko-KR\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6eaa1dedfb9710f350bbf8ccb317e7cfa2a5a277b535c6558bc57169262ec430?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6eaa1dedfb9710f350bbf8ccb317e7cfa2a5a277b535c6558bc57169262ec430?s=96&d=mm&r=g\",\"caption\":\"wizardlee\"},\"sameAs\":[\"http:\/\/dev.e-luda.com\/dev-note\"],\"url\":\"http:\/\/dev.e-luda.com\/dev-note\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"mysql \uba85\ub839\uc5b4 - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/dev.e-luda.com\/dev-note\/?p=68","og_locale":"ko_KR","og_type":"article","og_title":"mysql \uba85\ub839\uc5b4 - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8","og_description":"\ubc84\uc804 \ud655\uc778 : os command : mysql &#8211;version sql\ub85c \ud655\uc778 : SELECT VERSION() Database \uc0dd\uc131, \uc0ad\uc81c \uc0dd\uc131 : create database &lt;database name&gt;; \ubb38\uc790\uc5f4 encoding \uc9c0\uc815: create database &lt;database name&gt; default charset utf8; \uc0ad\uc81c: drop database &lt;database name&gt;;","og_url":"http:\/\/dev.e-luda.com\/dev-note\/?p=68","og_site_name":"\ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8","article_published_time":"2017-10-16T06:24:43+00:00","twitter_card":"summary_large_image","twitter_misc":{"Written by":"wizardlee"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"http:\/\/dev.e-luda.com\/dev-note\/#website","url":"http:\/\/dev.e-luda.com\/dev-note\/","name":"\ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8","description":"\ub2e4\ub978 \uc6cc\ub4dc\ud504\ub808\uc2a4 \uc0ac\uc774\ud2b8","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/dev.e-luda.com\/dev-note\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"ko-KR"},{"@type":"WebPage","@id":"http:\/\/dev.e-luda.com\/dev-note\/?p=68#webpage","url":"http:\/\/dev.e-luda.com\/dev-note\/?p=68","name":"mysql \uba85\ub839\uc5b4 - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8","isPartOf":{"@id":"http:\/\/dev.e-luda.com\/dev-note\/#website"},"datePublished":"2017-10-16T06:24:43+00:00","dateModified":"2017-10-16T06:24:43+00:00","author":{"@id":"http:\/\/dev.e-luda.com\/dev-note\/#\/schema\/person\/7e381f3b46b7824adbe15ff43b53c42c"},"breadcrumb":{"@id":"http:\/\/dev.e-luda.com\/dev-note\/?p=68#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["http:\/\/dev.e-luda.com\/dev-note\/?p=68"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/dev.e-luda.com\/dev-note\/?p=68#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/dev.e-luda.com\/dev-note"},{"@type":"ListItem","position":2,"name":"mysql \uba85\ub839\uc5b4"}]},{"@type":"Person","@id":"http:\/\/dev.e-luda.com\/dev-note\/#\/schema\/person\/7e381f3b46b7824adbe15ff43b53c42c","name":"wizardlee","image":{"@type":"ImageObject","@id":"http:\/\/dev.e-luda.com\/dev-note\/#personlogo","inLanguage":"ko-KR","url":"https:\/\/secure.gravatar.com\/avatar\/6eaa1dedfb9710f350bbf8ccb317e7cfa2a5a277b535c6558bc57169262ec430?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6eaa1dedfb9710f350bbf8ccb317e7cfa2a5a277b535c6558bc57169262ec430?s=96&d=mm&r=g","caption":"wizardlee"},"sameAs":["http:\/\/dev.e-luda.com\/dev-note"],"url":"http:\/\/dev.e-luda.com\/dev-note\/?author=1"}]}},"_links":{"self":[{"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=\/wp\/v2\/posts\/68","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=68"}],"version-history":[{"count":0,"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=\/wp\/v2\/posts\/68\/revisions"}],"wp:attachment":[{"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=68"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=68"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=68"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}