{"description":"Streak\u3092\u8a08\u7b97\u3057\u305f\u3044\u3068\u304d\u306b\u601d\u3044\u51fa\u3059SQL\u3002 SELECT MAX(streak) AS streak FROM ( SELECT tmp1.*, IF( @prev + INTERVAL 1 DAY = tmp1.date, @streak := @streak + 1, @streak := 1 ) AS streak, @prev := tmp1.date FROM ( SELECT date FROM logs WHERE user_id = ? group by date order by date asc ) AS tmp1 INNER JOIN (SELECT @prev :=\u2026","blog_title":"\u306f\u3044\uff01\u4eca\u3084\u3063\u3066\u307e\u3059\uff01","image_url":null,"provider_name":"Hatena Blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fyuji-ueda.hatenadiary.jp%2Fentry%2F2020%2F10%2F13%2F015301\" title=\"\u300c\u9023\u7d9a\u3007\u3007\u65e5\u3007\u3007\u3057\u307e\u3057\u305f\u300d\u307f\u305f\u3044\u306aStreak\u3092\u8a08\u7b97\u3057\u305f\u3044\u3068\u304d\u306eSQL\u3092MySQL\u3067 - \u306f\u3044\uff01\u4eca\u3084\u3063\u3066\u307e\u3059\uff01\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","type":"rich","version":"1.0","width":"100%","provider_url":"https://hatena.blog","title":"\u300c\u9023\u7d9a\u3007\u3007\u65e5\u3007\u3007\u3057\u307e\u3057\u305f\u300d\u307f\u305f\u3044\u306aStreak\u3092\u8a08\u7b97\u3057\u305f\u3044\u3068\u304d\u306eSQL\u3092MySQL\u3067","published":"2020-10-13 01:53:01","author_name":"yuji_ueda","author_url":"https://blog.hatena.ne.jp/yuji_ueda/","blog_url":"https://yuji-ueda.hatenadiary.jp/","categories":["MySQL","SQL"],"url":"https://yuji-ueda.hatenadiary.jp/entry/2020/10/13/015301","height":"190"}