Shanky Phoenix

DROP PROCEDURE `dg`// CREATE DEFINER=`root`@`localhost` PROCEDURE `dg`(g int(32)) begin declare p_a int(25); declare no_more_rows boolean default FALSE; declare cursor1 cursor for select id from chk; declare continue handler for not found set no_more_rows := TRUE; open cursor1; Loop1 : loop fetch cursor1 into p_a; if no_more_rows then close cursor1; leave Loop1; end if; select p_a; end loop Loop1; end

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 | +-------+-----------+-------------+----------+

DELETE t1 FROM mdl t1, mdl t2 WHERE t1.userid=t2.userid AND t1.fieldid=t2.fieldid AND t1.id < t2.id