aaa

DELIMITER //
CREATE PROCEDURE BOOKS_ISSUE_REGISTER()
BEGIN
    DECLARE V_ISSUEID INTEGER;
    DECLARE V_DOI DATE;
    DECLARE V_EXP_DOR DATE;
    DECLARE V_MEMBERID INTEGER;
    DECLARE FLAG INTEGER DEFAULT 0;

    DECLARE CUR CURSOR FOR
        SELECT ISSUE_ID, DATE_OF_ISSUE, EXPECTED_DATE_OF_RETURN, MEM_ID
        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_EXP_DOR, V_MEMBERID;
        IF FLAG = 1 THEN
            LEAVE GET_LIST;
        END IF;

        SELECT CONCAT(V_ISSUEID, ':', V_DOI, ':', V_EXP_DOR, ':', V_MEMBERID) AS REGISTER;
    END LOOP GET_LIST;

    CLOSE CUR;
END //
DELIMITER ;