[Solved] Create different result set using one result set [closed]
To use a resultset in a query condition for a set of queries you need a cursor. Please check out basics of cursor usage here and in the docs DELIMITER $$ CREATE PROCEDURE group_results_by_date BEGIN DECLARE v_finished INTEGER DEFAULT 0; DECLARE cdate DATE DEFAULT “2015-01-01”; — declare cursor for getting list of dates DEClARE date_cursor … Read more