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

SQL_CALC_FOUND_ROWS command fetch row count without limit

select SQL_CALC_FOUND_ROWS from <tablename> where flag = 1 limit 10 and then select found_rows();

Splitting Comma-Separated Values In MySQL

CREATE TABLE numbers (n INT); INSERT INTO numbers VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), select id, substring_index( substring_index(email_recipients, ',', n), ',', -1 ) as email from dashboards join numbers on char_length(email_recipients) - char_length(replace(email_recipients, ',', '')) >= n - 1 Reference Site : https://www.sisense.com/blog/splitting-comma-separated-values-in-mysql/

Custom Sorting Array List in PHP

<?php $order = array("Z","Srilanka","34", "Canada", "India", "USA"); $array = array( array('id' => 7867867, 'title' => 'USA'), array('id' => 3452342, 'title' => 'India'), array('id' => 1231233, 'title' => 'Srilanka'), array('id' => 5867867, 'title' => 'Z'), ); usort($array, function ($a, $b) use ($order) { $pos_a = array_search($a['title'], $order); $pos_b = array_search($b['title'], $order); return $pos_a - $pos_b; }); print_r($array); ?>

Shanky Phoenix

Search This Blog