asdfgh

DELIMITER //

CREATE PROCEDURE books_issue_register()
BEGIN
    DECLARE v_issueid INTEGER;
    DECLARE v_doi DATE;
    DECLARE v_book_id INTEGER;
    DECLARE v_memberid INTEGER;
    DECLARE v_exp_dor DATE;
    DECLARE flag INTEGER DEFAULT 0;

    DECLARE cur CURSOR FOR
        SELECT ISSUE_ID, DATE_OF_ISSUE, BOOK_ID, 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 v_issueid, v_doi, v_book_id, v_memberid, v_exp_dor;
        IF flag = 1 THEN
            LEAVE get_list;
        END IF;

        SELECT CONCAT(v_issueid, ':', v_doi, ':', v_book_id, ':', v_memberid, ':', v_exp_dor) AS register;
    END LOOP get_list;

    CLOSE cur;
END //

DELIMITER ;