Skip to main content

Mysql : Rollup command ..last row of the result will show the total of sum and count function

Rollup command ..last row of the result will show the total of sum and count function


SELECT month,sum(star),sum(rating),count(*) FROM `rolluptest` group by month with rollup


+-------+-----------+-------------+----------+
| month | sum(star) | sum(rating) | count(*) |
+-------+-----------+-------------+----------+
| Feb   |        19 |           4 |        3 |
| Jan   |         9 |           4 |        2 |
| Mar   |         1 |           3 |        1 |
| NULL  |        29 |          11 |        6 |
+-------+-----------+-------------+----------+

Comments

Post a Comment

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
Post a Comment
Read more

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 ); } ?>
Post a Comment
Read more