{"id":9530,"date":"2018-11-06T09:12:54","date_gmt":"2018-11-05T15:12:54","guid":{"rendered":"http:\/\/www.moonmile.net\/blog\/?p=9530"},"modified":"2018-11-06T13:09:18","modified_gmt":"2018-11-06T04:09:18","slug":"%e5%b0%8f%e5%ad%a6%e7%94%9f%e3%81%ae%e8%87%aa%e7%94%b1%e7%a0%94%e7%a9%b6%e3%81%ab%e6%9c%80%e9%81%a9-%e3%81%8b%e3%82%82%e3%81%97%e3%82%8c%e3%81%aa%e3%81%84%e4%b8%ad%e5%a4%ae%e5%8d%b8%e5%a3%b2","status":"publish","type":"post","link":"http:\/\/www.moonmile.net\/blog\/archives\/9530","title":{"rendered":"\u5c0f\u5b66\u751f\u306e\u81ea\u7531\u7814\u7a76\u306b\u6700\u9069…\u304b\u3082\u3057\u308c\u306a\u3044\u4e2d\u592e\u5378\u58f2\u5e02\u5834\u306e\u5378\u58f2\u6570\u91cf\u3092MySQL\u3067\u6271\u3046"},"content":{"rendered":"

\u7bc9\u5730\u5e02\u5834\u304b\u3089\u8c4a\u6d32\u5e02\u5834\u3078\u306e\u79fb\u8ee2\u306b\u95a2\u3057\u3066\u3001\u8af8\u3005\u3092\u8abf\u3079\u3066\u3044\u305f\u6642\u306b\u3061\u3087\u3046\u3069\u3088\u3055\u305d\u3046\u306a\u5927\u91cf\u30c7\u30fc\u30bf\u3092\u307f\u3064\u3051\u305f\u306e\u3067\u3001\u7d39\u4ecb\u304c\u3066\u3089\u3002<\/p>\n

\u4e2d\u592e\u5378\u58f2\u5e02\u5834\u306e\u5378\u58f2\u6570\u91cf\u306f\u516c\u958b\u3055\u308c\u3066\u3044\u308b<\/h2>\n

\u3044\u308f\u3086\u308b\u7bc9\u5730\u3068\u304b\u8c4a\u6d32\u3068\u304b\u306e\u5378\u58f2\u5e02\u5834\u306f\u90fd\u304c\u7d4c\u55b6\u3092\u3057\u3066\u3044\u3066\u3001\u3082\u308d\u3082\u308d\u306e\u60c5\u5831\u306f\u4ee5\u4e0b\u3067\u516c\u958b\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n

\u6771\u4eac\u90fd\u4e2d\u592e\u5378\u58f2\u5e02\u5834\u65e5\u5831
\nhttp:\/\/www.shijou-nippo.metro.tokyo.jp\/<\/a><\/p>\n

2004\u5e74\u304b\u3089\u8a18\u9332\u304c\u3042\u308b\u306e\u306710\u5e74\u4ee5\u4e0a\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002\u304c\u3001\u3042\u307e\u308a\u591a\u304f\u3066\u3082\u4ed5\u65b9\u304c\u306a\u3044\u306e\u3067\u3072\u3068\u307e\u305a5\u5e74\u9593\u5206\uff082013\u5e741\u6708\u304b\u30892018\u5e7411\u6708\uff09\u307e\u3067\u306e\u9752\u679c\u3068\u6c34\u7523\u306e\u30c7\u30fc\u30bf\u3092\u3068\u3063\u3066\u304d\u307e\u3057\u305f\u3002<\/p>\n

<\/a><\/p>\n

\u30da\u30fc\u30b8\u3092\u63a2\u3063\u3066\u3044\u304f\u3068\u3001\u3053\u3093\u306a\u5f62\u3067\u30c6\u30fc\u30d6\u30eb\u3067\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u3053\u308c\u3092CSV\u5f62\u5f0f\u3067\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n

<\/a><\/p>\n

CSV\u5f62\u5f0f\u3068\u306f\u3044\u3048\u3001\u3053\u3093\u306a\u98a8\u306b\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u3068\u3063\u3066\u304d\u305f\u3088\u3046\u306a\u5f62\u306eCSV\u5f62\u5f0f\u306a\u306e\u3067\uff08\u4e00\u5fdc\u30ab\u30f3\u30de\u533a\u5207\u308a\u306b\u306f\u306a\u3063\u3066\u3044\u308b\uff09\u3061\u3087\u3063\u3068\u6271\u3044\u306b\u304f\u3044\u306e\u3067\u3059\u3002<\/p>\n

\u516c\u958b\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u6574\u5f62\u3059\u308b<\/h2>\n

\u3053\u306e\u307e\u307e\u3067\u306f\u30c7\u30fc\u30bf\u3068\u3057\u3066\u6271\u3044\u3065\u3089\u3044\u306e\u3067\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u633f\u5165\u3067\u304d\u308b\u3088\u3046\u306b\u672c\u5f53\u306eCSV\u5f62\u5f0f\u306b\u76f4\u3057\u3066\u3057\u307e\u3044\u307e\u3059\u3002<\/p>\n

\r\nopen System\r\nopen System.IO\r\n\r\n\/\/ 1\u884c\u76ee: \u8ca9\u58f2\u7d50\u679c\uff08\u9752\u679c\u30fb\u5168\u5e02\u5834\uff09\u3000\u2192 \u68df\r\n\/\/ 2\u884c\u76ee: \u5e73\u621030\u5e7408\u670801\u65e5(\u6c34\u66dc\u65e5) \u2192 \u65e5\u4ed8\r\n\/\/ &quot;\uff08\u5358\u4f4d\uff1a\u30ad\u30ed\uff09&quot; \u3067 \u2192 \u5206\u985e\r\n\/\/ &quot;\u54c1\u540d...&quot; \u3067 \u2192 \u5e02\u5834\r\n\/\/ \u4ee5\u964d\u30011\u884c\u3054\u3068\u306b \u54c1\u7269, \u8ca9\u58f2\u65b9\u6cd5, \u5378\u58f2\u6570\u91cf\uff08\u5e02\u5834\u3054\u3068\uff09\r\n\/\/ \u305f\u3060\u3057\u3001\u5c0f\u8a08\u3001\u5168\u5206\u985e\u5408\u8a08\u306f\u53d6\u308a\u8fbc\u307e\u306a\u3044\r\n\r\n\/\/ \u51fa\u529b\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\r\n\/\/ \u65e5\u4ed8, \u68df, \u5206\u985e, \u5e02\u5834, \u54c1\u540d, \u8ca9\u58f2\u65b9\u6cd5, \u5378\u58f2\u6570\u91cf\r\n\r\nlet rec readtable (sr:System.IO.StreamReader) \u68df (\u65e5\u4ed8:DateTime) \u5206\u985e (\u5e02\u5834:string[]) \u54c1\u540d_ =\r\n    let \u6570\u91cf = sr.ReadLine().Split(&quot;,&quot;)\r\n    let \u54c1\u540d = if \u6570\u91cf.[0] <> &quot;&quot; then \u6570\u91cf.[0] else \u54c1\u540d_\r\n    if \u6570\u91cf.[0] <> &quot;\u5c0f\u8a08&quot; then\r\n        for i in [4..\u5e02\u5834.Length-1] do\r\n            let \u5e02\u5834\u540d = \u5e02\u5834.[i]\r\n            let \u5378\u58f2\u6570\u91cf = if \u6570\u91cf.[i] = &quot;\u2212&quot; then &quot;0&quot; else \u6570\u91cf.[i]\r\n            let \u8ca9\u58f2\u65b9\u6cd5 = \u6570\u91cf.[2]\r\n            printfn &quot;%s&quot; (\r\n                String.Format(&quot;{0},{1},{2},{3},{4},{5},{6}&quot;, \r\n                    \u65e5\u4ed8.ToString(&quot;yyyy\/MM\/dd&quot;), \r\n                    \u68df,\r\n                    \u5206\u985e,\r\n                    \u5e02\u5834\u540d,\r\n                    \u54c1\u540d,\r\n                    \u8ca9\u58f2\u65b9\u6cd5,\r\n                    \u5378\u58f2\u6570\u91cf  ))\r\n        readtable sr \u68df \u65e5\u4ed8 \u5206\u985e \u5e02\u5834 \u54c1\u540d\r\n    ()\r\n\r\nlet readblock (sr:System.IO.StreamReader) \u68df \u65e5\u4ed8 =\r\n    let \u5206\u985e = sr.ReadLine().Replace(&quot;\uff08\u5358\u4f4d\uff1a\u30ad\u30ed\uff09&quot;,&quot;&quot;)\r\n    let \u5e02\u5834 = sr.ReadLine().Split(&quot;,&quot;)\r\n    if \u5206\u985e <> &quot;\u5168\u5206\u985e\u5408\u8a08&quot; then\r\n        readtable sr \u68df \u65e5\u4ed8 \u5206\u985e \u5e02\u5834 &quot;&quot;\r\n    ()\r\n\r\nlet readcsv (sr:System.IO.StreamReader) =\r\n\r\n    let \u68df = sr.ReadLine().Replace(&quot;\u8ca9\u58f2\u7d50\u679c\uff08&quot;,&quot;&quot;).Replace(&quot;\u30fb\u5168\u5e02\u5834\uff09&quot;,&quot;&quot;)\r\n    let ci = new System.Globalization.CultureInfo(&quot;ja-JP&quot;)\r\n    let \u65e5\u4ed8 = DateTime.Parse( \r\n                sr.ReadLine().Substring(0,11), \r\n                new System.Globalization.CultureInfo(&quot;ja-JP&quot;), \r\n                System.Globalization.DateTimeStyles.AssumeLocal)\r\n    sr.ReadLine() |> ignore \/\/ \u7a7a\u884c\r\n    while sr.EndOfStream = false do\r\n        readblock sr \u68df \u65e5\u4ed8\r\n        \/\/ \u7a7a\u884c\u307e\u3067\u8aad\u307f\u6368\u3066\r\n        while sr.EndOfStream = false && sr.ReadLine() <> &quot;&quot; do\r\n            () \r\n    ()\r\n\r\n[<EntryPoint>]\r\nlet main argv =\r\n    if argv.Length = 0 then\r\n        printfn &quot;ex. tukizi sui_20181105.csv&quot;\r\n    else\r\n        \/\/ printfn &quot;%s&quot; argv.[0]\r\n        for fname in argv do\r\n            let sr = new System.IO.StreamReader( fname )\r\n            readcsv sr\r\n            sr.Close()\r\n    0\r\n<\/pre>\n
\u30b3\u30fc\u30c9\u304cF#\u306b\u306a\u3063\u3066\u3044\u308b\u306e\u306f\u3044\u3064\u3082\u306e\u3053\u3068\u3067\u3059\u306d\u3002\u3053\u306e\u624b\u306e\u6574\u5f62\u3092\u3084\u308b\u306e\u306fC#\u3088\u308a\u3082F#\u3067\u66f8\u3044\u305f\u307b\u3046\u304c\u3084\u308a\u3084\u3059\u304b\u3063\u305f\u308a\u3057\u307e\u3059\u3002\u4e00\u756a\u5185\u5074\u306e readtable \u95a2\u6570\u5185\u3067\u518d\u5e30\u3092\u4f7f\u3063\u3066\u54c1\u540d\u306e\u90e8\u5206\u3092\u8aad\u307f\u8fbc\u3093\u3067\u3044\u307e\u3059\u3002\u3082\u3063\u3068\u9811\u5f35\u308c\u3070 for \u30eb\u30fc\u30d7\u3092\u7121\u304f\u305b\u308b\u306f\u305a\u306a\u306e\u3067\u3057\u3087\u3046\u304c\u3001\u3072\u3068\u307e\u305a\u3053\u308c\u52d5\u3044\u305f\u306e\u3067ok\u3068\u3044\u3046\u3053\u3068\u3067\u3002<\/p>\n
\u4f55\u304c\u3067\u304d\u308b\u306e\u304b\uff1f<\/h2>\n
\u30c7\u30fc\u30bf\u91cf\u306f\u3056\u3063\u3068200\u4e07\u4ef6\u8fd1\u304f\u3042\u308a\u307e\u3059\u3002200\u4e07\u4ef6\u3042\u308b\u3068\u691c\u7d22\u304c\u91cd\u305f\u304f\u306a\u3063\u3066\u5927\u5909\u306a\u306e\u3067\u306f\uff1f\u3068\u601d\u3063\u3066\u3044\u305f\u306e\u3067\u3059\u304c\u3001MySQL \u306b\u7a81\u3063\u8fbc\u3081\u3070\u5168\u7136\u5e73\u6c17\u3067\u3059\u306d\u3002\u3072\u3068\u3064\u306e\u30c6\u30fc\u30d6\u30eb\u3057\u304b\u6271\u308f\u306a\u3044\u3068\u3044\u3046\u306e\u3082\u3042\u308b\u306e\u3067\u3059\u304c\uff08\u9762\u5012\u306a\u306e\u3067\u6562\u3048\u3066\u6b63\u898f\u5316\u3057\u3066\u3044\u307e\u305b\u3093\uff09\u3001\u4e00\u5343\u4e07\u4ef6\u3050\u3089\u3044\u3042\u308b\u3068\u691c\u7d22\u306b\u6642\u9593\u304c\u639b\u304b\u308b\u306e\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u304c\u3001200\u4e07\u4ef6\u4f4d\u3060\u3063\u305f\u3089 sum \u3092\u4f7f\u3063\u3066\u96c6\u8a08\u3057\u3066\u3082\u5168\u7136\u3042\u3063\u3068\u3044\u3046\u9593\u306b\u7d42\u308f\u308a\u307e\u3059\u3002<\/p>\n
\u5b9f\u306f200\u4e07\u4ef6\u306e\u5b9f\u30c7\u30fc\u30bf\u3092\u96c6\u3081\u308b\u306e\u306f\u7d50\u69cb\u5927\u5909\u306a\u306e\u3067\u3059\u3002\u8abf\u67fb\u3059\u308b\u306b\u3057\u3066\u3082\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u52c9\u5f37\u3092\u3059\u308b\u306b\u3057\u3066\u3082\u3001\u3053\u308c\u3060\u3051\u306e\u30c7\u30fc\u30bf\u3092\u6271\u3048\u308b\u306e\u306f\u7d50\u69cb\u8cb4\u91cd\u3067\u306f\u306a\u3044\u304b\u306a\uff1f\u3068\u601d\u3046\u306e\u3067\u3059\u3002<\/p>\n
5\u5e74\u9593\u5206\u306e\u30c7\u30fc\u30bf\u306f https:\/\/1drv.ms\/u\/s!AmXmBbuizQkXgpUYeqUVYd7WhAl4uw<\/a> \u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u304f\u3060\u3055\u3044\u3002MySQL\u306b\u5165\u308c\u3066\u304b\u3089\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u305f\u30c7\u30fc\u30bf\u3068\u3001\u5148\u306e\u30c4\u30fc\u30eb\u3067\u6210\u5f62\u3057\u305fCSV\u5f62\u5f0f\u306e\u30c7\u30fc\u30bf\u304c\u5165\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n
\u30c6\u30fc\u30d6\u30eb\u69cb\u9020\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002\u9762\u5012\u3060\u3063\u305f\u306e\u3067\u5217\u540d\u306f\u65e5\u672c\u8a9e\u306e\u307e\u307e\uff57<\/p>\n
\r\nCREATE TABLE `tt` (\r\n  `\u65e5\u4ed8` datetime NOT NULL,\r\n  `\u68df` varchar(45) NOT NULL,\r\n  `\u5206\u985e` varchar(45) NOT NULL,\r\n  `\u5e02\u5834` varchar(45) NOT NULL,\r\n  `\u54c1\u540d` varchar(45) NOT NULL,\r\n  `\u8ca9\u58f2\u65b9\u6cd5` varchar(45) NOT NULL,\r\n  `\u5378\u58f2\u6570\u91cf` double NOT NULL\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n<\/pre>\n
\u53bb\u5e74\u306e\u3055\u3093\u307e\u306e\u5378\u58f2\u6570\u91cf\u3092\u8abf\u3079\u3066\u307f\u3088\u3046<\/h2>\n
\u4f8b\u3048\u3070\u3001\u53bb\u5e741\u5e74\u9593\u306e\u300c\u3055\u3093\u307e\u300d\u306e\u53d6\u6271\u91cf\u3092\u307f\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n
\r\nselect \u65e5\u4ed8, sum(\u5378\u58f2\u6570\u91cf) from TT \r\nwhere \u54c1\u540d = '\u3055\u3093\u307e'\r\n  and \u65e5\u4ed8 between '2017\/01\/01' and '2017\/12\/31'\r\ngroup by \u65e5\u4ed8\r\norder by \u65e5\u4ed8\r\n;\r\n<\/pre>\n
\u3053\u3093\u306a\u30af\u30a8\u30ea\u3092\u66f8\u3044\u3066\u65e5\u4ed8\u3067\u30bd\u30fc\u30c8\u3059\u308c\u3070\u3001\u65e5\u5358\u4f4d\u306e\u5378\u58f2\u6570\u91cf\u304c\u308f\u304b\u308a\u307e\u3059\u3002<\/p>\n
<\/a><\/p>\n
\u7d50\u679c\u3092Excel\u306b\u8cbc\u308a\u4ed8\u3051\u3066\u30b0\u30e9\u30d5\u3092\u8ffd\u52a0\u3059\u308c\u3070\u3001\u307b\u3089\u81ea\u7531\u7814\u7a76\u306e\u3067\u304d\u3042\u304c\u308a\u3002<\/p>\n
<\/a><\/p>\n
\u3061\u306a\u307f\u306b\u30d5\u30a9\u30f3\u30c8\u306f\u300c\u5168\u5150\u7ae5\u30d5\u30a9\u30f3\u30c8\uff08\u30d5\u30a7\u30eb\u30c8\u30da\u30f3\uff09\u300d http:\/\/tanukifont.com\/zenjido\/<\/a> \u3092\u4f7f\u3063\u3066\u3044\u307e\u3059\u3002\u304a\u8a66\u3057\u3042\u308c\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u7bc9\u5730\u5e02\u5834\u304b\u3089\u8c4a\u6d32\u5e02\u5834\u3078\u306e\u79fb\u8ee2\u306b\u95a2\u3057\u3066\u3001\u8af8\u3005\u3092\u8abf\u3079\u3066\u3044\u305f\u6642\u306b\u3061\u3087\u3046\u3069\u3088\u3055\u305d\u3046\u306a\u5927\u91cf\u30c7\u30fc\u30bf\u3092\u307f\u3064\u3051\u305f\u306e\u3067\u3001\u7d39\u4ecb\u304c\u3066\u3089\u3002 \u4e2d\u592e\u5378\u58f2\u5e02\u5834\u306e\u5378\u58f2\u6570\u91cf\u306f\u516c\u958b\u3055\u308c\u3066\u3044\u308b \u3044\u308f\u3086\u308b\u7bc9\u5730\u3068\u304b\u8c4a\u6d32\u3068\u304b\u306e\u5378\u58f2\u5e02\u5834\u306f\u90fd\u304c\u7d4c\u55b6\u3092\u3057\u3066\u3044\u3066\u3001\u3082\u308d\u3082\u308d … \u7d9a\u304d\u3092\u8aad\u3080 →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-9530","post","type-post","status-publish","format-standard","hentry","category-dev"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts\/9530","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/comments?post=9530"}],"version-history":[{"count":7,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts\/9530\/revisions"}],"predecessor-version":[{"id":9537,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts\/9530\/revisions\/9537"}],"wp:attachment":[{"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/media?parent=9530"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/categories?post=9530"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/tags?post=9530"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}