{"published":"2015-10-26 16:29:03","author_name":"aipacommander","author_url":"https://blog.hatena.ne.jp/aipacommander/","blog_url":"https://aipacommander.com/","width":"100%","description":"\u3057\u304b\u3082\u3001\u81ea\u5206\u306e\u4e2d\u3067\u554f\u984c\u306b\u306a\u3063\u3066\u3044\u305f\u3002\u300c\u5b58\u5728\u3057\u306a\u3044\u65e5\u4ed8\u306e\u6708\u96c6\u8a08\u300d\u3082\u3053\u308c\u3092\u4f7f\u3048\u3070\u89e3\u6c7a\u3067\u304d\u307e\u3057\u305f\u3002 select * FROM (SELECT CAST(DATE_FORMAT('2014-01-01', '%Y%m') + CAST(VIRTUAL.generate_series AS UNSIGNED) as CHAR) AS ym FROM (select 0 generate_series from dual where (@num:=1 - 2) * 0 union all select @num:=@num + 1 from `information_schema`.columns li\u2026","categories":["SQL","MySQL"],"type":"rich","blog_title":"IT\u306e\u968a\u9577\u306e\u30d6\u30ed\u30b0","url":"https://aipacommander.com/entry/2015/10/26/162903","provider_name":"Hatena Blog","image_url":"http://ecx.images-amazon.com/images/I/51CGypjLrvL.jpg","provider_url":"https://hatena.blog","height":"190","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Faipacommander.com%2Fentry%2F2015%2F10%2F26%2F162903\" title=\"MySQL\u3063\u3066\u5909\u6570\u4f7f\u3048\u305f\u3093\u3067\u3059\u306d(\u00b4\uff1b\u03c9\uff1b\uff40)\uff8c\uff9e\uff9c\uff6f - IT\u306e\u968a\u9577\u306e\u30d6\u30ed\u30b0\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","title":"MySQL\u3063\u3066\u5909\u6570\u4f7f\u3048\u305f\u3093\u3067\u3059\u306d(\u00b4\uff1b\u03c9\uff1b\uff40)\uff8c\uff9e\uff9c\uff6f","version":"1.0"}