athul

DELIMITER $$

CREATE PROCEDURE get_record()
BEGIN
    DECLARE id INT;
    DECLARE d_i DATE;
    DECLARE m_id INT;
    DECLARE exp_d DATE;
    DECLARE flag INT DEFAULT 0;

    DECLARE cur CURSOR FOR 
        SELECT issue_id, date_of_issue, member_id, expected_date_of_return FROM book_issue;

    DECLARE CONTINUE HANDLER FOR NOT FOUND SET flag = 1;

    OPEN cur;

    get_list: LOOP
        FETCH cur INTO id, d_i, m_id, exp_d;
        IF flag = 1 THEN 
            LEAVE get_list;
        END IF;

        SELECT CONCAT(id, ':', d_i, ':', exp_d) AS register;
    END LOOP get_list;

    CLOSE cur;
END $$

DELIMITER ;