{"id":276,"date":"2022-06-21T08:44:35","date_gmt":"2022-06-20T23:44:35","guid":{"rendered":"https:\/\/www.b64.pw\/blog\/?p=276"},"modified":"2022-06-21T08:44:36","modified_gmt":"2022-06-20T23:44:36","slug":"%e3%83%87%e3%82%a3%e3%83%ac%e3%82%af%e3%83%88%e3%83%aa%e3%81%ab%e3%81%82%e3%82%8bmysql%e3%82%92%e4%b8%80%e6%8b%ac%e3%81%a7%e9%81%a9%e7%94%a8%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"http:\/\/www.b64.pw\/blog\/?p=276","title":{"rendered":"\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u3042\u308bmysql\u3092\u4e00\u62ec\u3067\u9069\u7528\u3059\u308b"},"content":{"rendered":"\n<p>\u4e0b\u8a18\u306e\u3088\u3046\u306asql\u30d5\u30a1\u30a4\u30eb\u304c\u4e26\u3093\u3067\u3044\u308b\u3088\u3046\u306a\u72b6\u6cc1\u3067\u3001\u3053\u308c\u3092\u3059\u3079\u3066\u9069\u7528\u3057\u305f\u3044\u5834\u5408<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>alter_20220601.sql\nalter_20220602.sql\nalter_20220603.sql<\/code><\/pre>\n\n\n\n<p>\u3053\u306e\u3088\u3046\u306b\u3059\u308b\u3068\u697d<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-bash\" data-lang=\"Bash\"><code>cd \/path\/to\/sql\/ && ls *.sql|sort|xargs -I{} bash -c &#39;mysql -u root -P 4000 -h 127.0.0.1 &lt; {}&#39;<\/code><\/pre><\/div>\n\n\n\n<p>bash -c\u3067\u6e21\u3059\u306e\u304c\u30dd\u30a4\u30f3\u30c8\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e0b\u8a18\u306e\u3088\u3046\u306asql\u30d5\u30a1\u30a4\u30eb\u304c\u4e26\u3093\u3067\u3044\u308b\u3088\u3046\u306a\u72b6\u6cc1\u3067\u3001\u3053\u308c\u3092\u3059 &#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[],"_links":{"self":[{"href":"http:\/\/www.b64.pw\/blog\/index.php?rest_route=\/wp\/v2\/posts\/276"}],"collection":[{"href":"http:\/\/www.b64.pw\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.b64.pw\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.b64.pw\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.b64.pw\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=276"}],"version-history":[{"count":1,"href":"http:\/\/www.b64.pw\/blog\/index.php?rest_route=\/wp\/v2\/posts\/276\/revisions"}],"predecessor-version":[{"id":277,"href":"http:\/\/www.b64.pw\/blog\/index.php?rest_route=\/wp\/v2\/posts\/276\/revisions\/277"}],"wp:attachment":[{"href":"http:\/\/www.b64.pw\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.b64.pw\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=276"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.b64.pw\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}