创建一个存储过程,该存储过程使用了游标来遍历employees表中的所有数据,并打印出这些员工的详细信息。(全部大写)DELIMITER $$
CREATE ()get_employee_details()
BEGIN
DECLARE done INT DEFAULT FALSE;
DECLARE employee_id INT;
DECLARE employee_name VARCHAR(255);
DECLARE employee_salary FLOAT;
DECLARE employee_cursor ()FOR SELECT id, name, salary FROM employees;
DECLARE ()HANDLER FOR NOT FOUND SET done = ();
()employee_cursor;
read_loop: LOOP
()employee_cursor INTO employee_id, employee_name, employee_salary;
IF done THEN
LEAVE read_loop;
END IF;
SELECT CONCAT('Employee ID: ', employee_id, 'Name: ', employee_name, 'Salary: ', employee_salary);
END LOOP;
()employee_cursor;
END$$
DELIMITER ;