{"id":1308,"date":"2011-09-27T23:45:22","date_gmt":"2011-09-27T14:45:22","guid":{"rendered":"http:\/\/movinow-sober.com\/blog\/?p=1308"},"modified":"2012-09-07T23:31:11","modified_gmt":"2012-09-07T14:31:11","slug":"mysql-with-rollup","status":"publish","type":"post","link":"https:\/\/movinow-sober.com\/blog\/2011\/09\/27\/mysql-with-rollup\/","title":{"rendered":"Mysql \u3067\u96c6\u8a08\u884c\u306e\u8ffd\u52a0 with rollup"},"content":{"rendered":"<p>Mysql \u306b\u3064\u3044\u3066\u3001group by \u3067\u30ab\u30a6\u30f3\u30c8\u3057\u3066\u3001\u6700\u5f8c\u306b\u5408\u8a08\u3092\u8868\u793a\u3059\u308b\u3084\u308a\u65b9\u3002<\/p>\n<p>\u3067\u304d\u3066\u5f53\u305f\u308a\u524d\u306e\u3088\u3046\u3060\u3051\u3069\u3001\u898b\u5f53\u304c\u3064\u304b\u306a\u304b\u3063\u305f\u3002\u8abf\u3079\u305f\u3089\u7c21\u5358\u306b\u3067\u304d\u305f\u306e\u3067\u30e1\u30e2\u3002<\/p>\n<p>[sql gutter=&#8221;false&#8221;]mysql&gt; select kousinbi,count(*) from tairyu_tmp group by kousinbi;<br \/>\n+&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;-+<br \/>\n| kousinbi?? | count(*) |<br \/>\n+&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;-+<br \/>\n| 2011-08-27 |??????? 3 |<br \/>\n| 2011-09-07 |??????? 1 |<br \/>\n| 2011-09-09 |??????? 1 |<br \/>\n| 2011-09-10 |??????? 2 |<br \/>\n| 2011-09-11 |????? 242 |<br \/>\n| 2011-09-12 |????? 300 |<br \/>\n| 2011-09-13 |????? 419 |<br \/>\n| 2011-09-14 |????? 232 |<br \/>\n| 2011-09-15 |????? 448 |<br \/>\n| 2011-09-16 |?????? 15 |<br \/>\n| 2011-09-17 |???? 1449 |<br \/>\n| 2011-09-20 |???? 1080 |<br \/>\n| 2011-09-21 |???? 2342 |<br \/>\n| 2011-09-22 |????? 260 |<br \/>\n| 2011-09-23 |???? 1538 |<br \/>\n| 2011-09-24 |???? 1319 |<br \/>\n| 2011-09-26 |?????? 35 |<br \/>\n| 2011-09-27 |???? 4073 |<br \/>\n+&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;-+<br \/>\n18 rows in set (0.56 sec)<br \/>\n[\/sql]<\/p>\n<p>&nbsp;<\/p>\n<h4>\u6700\u5f8c\u306b <span style=\"color: #ff0000;\">with rollup<\/span> \u3092\u3064\u3051\u308b\u305d\u3046\u306a\u3002\u304a\u307f\u3054\u3068\u3002<br \/>\n[sql gutter=&#8221;false&#8221; highlight_lines=&#8221;23&#8243;]mysql&gt; select kousinbi,count(*) from tairyu_tmp group by kousinbi with rollup;<br \/>\n+&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;-+<br \/>\n| kousinbi?? | count(*) |<br \/>\n+&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;-+<br \/>\n| 2011-08-27 |??????? 3 |<br \/>\n| 2011-09-07 |??????? 1 |<br \/>\n| 2011-09-09 |??????? 1 |<br \/>\n| 2011-09-10 |??????? 2 |<br \/>\n| 2011-09-11 |????? 242 |<br \/>\n| 2011-09-12 |????? 300 |<br \/>\n| 2011-09-13 |????? 419 |<br \/>\n| 2011-09-14 |????? 232 |<br \/>\n| 2011-09-15 |????? 448 |<br \/>\n| 2011-09-16 |?????? 15 |<br \/>\n| 2011-09-17 |???? 1449 |<br \/>\n| 2011-09-20 |???? 1080 |<br \/>\n| 2011-09-21 |???? 2342 |<br \/>\n| 2011-09-22 |????? 260 |<br \/>\n| 2011-09-23 |???? 1538 |<br \/>\n| 2011-09-24 |???? 1319 |<br \/>\n| 2011-09-26 |?????? 35 |<br \/>\n| 2011-09-27 |???? 4073 |<br \/>\n| NULL?????? |??? 13759 |<br \/>\n+&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;-+<br \/>\n19 rows in set (0.56 sec)[\/sql]<\/h4>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mysql \u306b\u3064\u3044\u3066\u3001group by \u3067\u30ab\u30a6\u30f3\u30c8\u3057\u3066\u3001\u6700\u5f8c\u306b\u5408\u8a08\u3092\u8868\u793a\u3059\u308b\u3084\u308a\u65b9\u3002 \u3067\u304d\u3066\u5f53\u305f\u308a\u524d\u306e\u3088\u3046\u3060\u3051\u3069\u3001\u898b\u5f53\u304c\u3064\u304b\u306a\u304b\u3063\u305f\u3002\u8abf\u3079\u305f\u3089\u7c21\u5358\u306b\u3067\u304d\u305f\u306e\u3067\u30e1\u30e2\u3002 [sql gutter=&#8221;false&#038;#8 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":7719,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-1308","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tec"],"views":7812,"_links":{"self":[{"href":"https:\/\/movinow-sober.com\/blog\/wp-json\/wp\/v2\/posts\/1308","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/movinow-sober.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/movinow-sober.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/movinow-sober.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/movinow-sober.com\/blog\/wp-json\/wp\/v2\/comments?post=1308"}],"version-history":[{"count":0,"href":"https:\/\/movinow-sober.com\/blog\/wp-json\/wp\/v2\/posts\/1308\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/movinow-sober.com\/blog\/wp-json\/wp\/v2\/media\/7719"}],"wp:attachment":[{"href":"https:\/\/movinow-sober.com\/blog\/wp-json\/wp\/v2\/media?parent=1308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/movinow-sober.com\/blog\/wp-json\/wp\/v2\/categories?post=1308"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/movinow-sober.com\/blog\/wp-json\/wp\/v2\/tags?post=1308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}