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

Popular posts from this blog

Enable Https by self-signing certification.

  Run make-ssl-cert command > sudo make-ssl-cert generate-default-snakeoil will created 2 files in following directory.     - /etc/ssl/certs/ssl-cert-snakeoil.pem     - /etc/ssl/private/ssl-cert-snakeoil.key Open /etc/apache2/site-avilable and find and modify with below line (with above certs paths) .         SSLCertificateFile    /etc/ssl/certs/ssl-cert-snakeoil.pem         SSLCertificateKeyFile /etc/ssl/private/ssl-cert-snakeoil.key > sudo a2ensite default-ssl > sudo a2enmode ssl > sudo systemctl restart apache2 Open https://localhost

simple recursive function to copy entire directories

<?php function recurse_copy ( $src , $dst ) {     $dir = opendir ( $src );     @ mkdir ( $dst );     while( false !== ( $file = readdir ( $dir )) ) {         if (( $file != '.' ) && ( $file != '..' )) {             if ( is_dir ( $src . '/' . $file ) ) {                 recurse_copy ( $src . '/' . $file , $dst . '/' . $file );             }             else {                 copy ( $src . '/' . $file , $dst . '/' . $file );             }         }     }     closedir ( $dir ); } ?>