Skip to main content

Mysql: Group Consecutive repeated row




event_id       event_name
----------------------------------------------
1                  Add
2                  Edit
2                  Edit
3                  Delete
3                  Delete
3                  Delete
1                  Add
1                  Add
1                  Add

Result
event_id       event_name  eve 
----------------------------------------------
1                  Add              1
2                  Edit              2
2                  Edit              2
3                  Delete          3
3                  Delete          3
3                  Delete          3
1                  Add              4
1                  Add              4
1                  Add              4
    
SELECT id,event_id,if(main.event_id = @eve,@eve,@row:=@row+1),@eve:=main.event_id,@row FROM `reso_event_log` as main,(select @row:=0,@eve:=0) as r order by main.id desc

Comments