{"id":984,"date":"2019-05-17T21:53:53","date_gmt":"2019-05-17T12:53:53","guid":{"rendered":"http:\/\/www.junotec.co.jp\/?p=984"},"modified":"2019-05-08T21:48:41","modified_gmt":"2019-05-08T12:48:41","slug":"%e4%bc%91%e3%81%bf%e6%b0%97%e5%88%86%e3%82%82%e3%81%a9%e3%81%93%e3%81%b8","status":"publish","type":"post","link":"https:\/\/www.junotec.co.jp\/blog\/?p=984","title":{"rendered":"\u30e2\u30e4\u30e2\u30e4\u3055\u25cb\u3041\uff5e\u305a"},"content":{"rendered":"<p>\u4ee5\u524d\u304b\u3089\u4f55\u3068\u306a\u304f\u30e2\u30e4\u30e2\u30e4\u3057\u3066\u3044\u305f\u306e\u3067\u3059\u304c\u3001<br \/>\nmysql\u3067schema\u306e\u6982\u5ff5\u306f\u7121\u3044\u306f\u305a\u3067\u3059\u304cshow databases\u3067\u30b9\u30ad\u30fc\u30de\u306e\u540d\u304c\u767b\u5834\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"lang:default decode:true\">mysql&gt; show databases;\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| information_schema |\r\n| mysql              |\r\n| performance_schema |\r\n| sys                |\r\n+--------------------+\r\n<\/pre>\n<p><a href=\"https:\/\/enterprisezine.jp\/dbonline\/detail\/5713\">\u3053\u3053<\/a>\u304b\u3089\u5f15\u7528<\/p>\n<pre class=\"lang:default decode:true \">INFORMATION_SCHEMA\u306f\u6a19\u6e96\u898f\u683cANSI\/ISO SQL:2003\u306eSchemata\u306e\u5b9a\u7fa9\u306b\u5f93\u3063\u3066\u304a\u308a\u3001\r\nSQL:2003\u306e\u30b3\u30a2\u3067\u3042\u308bF021 Basic information schema\u306b\u6e96\u62e0\u3059\u308b\u3088\u3046\u306b\u5b9f\u88c5\u3055\u308c\u3066\u3044\u307e\u3059\u3002\r\n<\/pre>\n<p>\u30e2\u30e4\u30e2\u30e4\u304c\u3068\u308c\u3066\u3059\u3063\u304d\u308a\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4ee5\u524d\u304b\u3089\u4f55\u3068\u306a\u304f\u30e2\u30e4\u30e2\u30e4\u3057\u3066\u3044\u305f\u306e\u3067\u3059\u304c\u3001 mysql\u3067schema\u306e\u6982\u5ff5\u306f\u7121\u3044 &hellip; <a href=\"https:\/\/www.junotec.co.jp\/blog\/?p=984\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6,3],"tags":[],"_links":{"self":[{"href":"https:\/\/www.junotec.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/984"}],"collection":[{"href":"https:\/\/www.junotec.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.junotec.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.junotec.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.junotec.co.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=984"}],"version-history":[{"count":4,"href":"https:\/\/www.junotec.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/984\/revisions"}],"predecessor-version":[{"id":988,"href":"https:\/\/www.junotec.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/984\/revisions\/988"}],"wp:attachment":[{"href":"https:\/\/www.junotec.co.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=984"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.junotec.co.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=984"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.junotec.co.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=984"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}