Update consecutive-numbers.sql

kamyu104 · kamyu104 · commit ef630f713de1 · 2015-01-13T20:19:34.000+08:00
diff --git a/MySQL/consecutive-numbers.sql b/MySQL/consecutive-numbers.sql
@@ -24,8 +24,6 @@ FROM (
     Num,
     @counter := IF(@prev = Num, @counter + 1, 1) AS how_many_cnt_in_a_row,
     @prev := Num
-    FROM
-    Logs y
-    , (SELECT @counter:=1, @prev:=NULL) vars
+    FROM Logs y, (SELECT @counter:=1, @prev:=NULL) vars
 ) sq
 WHERE how_many_cnt_in_a_row >= 3
