详解MySQL存储过程的结果集

CREATE PROCEDURE myProc(IN a INT, IN b INT)BEGIN    DECLARE result INT;    SET result = a * b;    RETURN result;END;

CREATE PROCEDURE myProc(IN a INT, IN b INT, OUT sum INT, OUT difference INT)BEGIN    SET sum = a + b;    SET difference = a - b;END;

CREATE PROCEDURE myProc()BEGIN    SELECT * FROM Employee;END;

CREATE PROCEDURE myProc(IN employeeID INT, OUT employeeName VARCHAR(255))BEGIN    SELECT name INTO @employeeName FROM Employee WHERE ID = employeeID;    SET employeeName = @employeeName;END;

CREATE PROCEDURE myProc()BEGIN    DECLARE employeeName VARCHAR(255);    DECLARE done INT DEFAULT FALSE;    DECLARE cur CURSOR FOR SELECT name FROM Employee;    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;        OPEN cur;        get_employee: LOOP        FETCH cur INTO employeeName;                IF done THEN            LEAVE get_employee;        END IF;                SELECT employeeName;    END LOOP;        CLOSE cur;END;

CREATE PROCEDURE myProc()BEGIN    DECLARE employeeName VARCHAR(255);    DECLARE cur CURSOR FOR SELECT name FROM Employee;        OPEN cur;        get_employee: LOOP        FETCH cur INTO employeeName;                IF done THEN            LEAVE get_employee;        END IF;                SELECT employeeName;    END LOOP;        CLOSE cur;END;

CREATE PROCEDURE myProc()BEGIN    SELECT *    FROM Employee    WHERE departmentID = (        SELECT ID FROM Department WHERE name = 'Sales'    );END;

CREATE INDEX idx_employee ON Employee(ID);

CREATE PROCEDURE myProc()BEGIN    SELECT *    FROM Employee    LIMIT 10;END;

CREATE TEMPORARY TABLE tempEmployee ENGINE=MEMORYSELECT * FROM Employee;