{"type":"rich","version":"1.0","provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/h_sakurai/","blog_title":"Scala \u3067 TAPL\u3092\u52c9\u5f37\u3057\u3064\u3064 LLVM \u30b3\u30f3\u30d1\u30a4\u30e9\u3092\u4f5c\u308b\u65e5\u8a18","title":"\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30cb\u30f3\u30b0\u30e1\u30e2","provider_url":"https://hatena.blog","width":"100%","height":"190","image_url":null,"description":"\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u30cb\u30f3\u30b0\u4ed8\u304d\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210 CREATE TABLE ti (id INT, amount DECIMAL(7,2), tr_date DATE) ENGINE=INNODB PARTITION BY HASH( MONTH(tr_date) ) PARTITIONS 6; \u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u524a\u9664 ALTER TABLE `ti` REMOVE PARTITIONING; \u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u8ffd\u52a0 ALTER TABLE ti PARTITION BY HASH( MONTH(tr_date) ) PARTITIONS 6;","published":"2011-11-30 00:00:00","author_name":"h_sakurai","blog_url":"https://h-sakurai.hatenadiary.org/","categories":["mysql"],"url":"https://h-sakurai.hatenadiary.org/entry/20111130/p1","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fh-sakurai.hatenadiary.org%2Fentry%2F20111130%2Fp1\" title=\"\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30cb\u30f3\u30b0\u30e1\u30e2 - Scala \u3067 TAPL\u3092\u52c9\u5f37\u3057\u3064\u3064 LLVM \u30b3\u30f3\u30d1\u30a4\u30e9\u3092\u4f5c\u308b\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>"}