sql游标练习题创建过程

创建一个过程，只要用户输入玩具名称，就可显示toys标准玩具的ID和描述记录

创建存储过程

delimiter $
CREATE PROCEDURE show_toy_details (IN toy_name VARCHAR(255))
BEGIN  
      DECLARE done INT DEFAULT FALSE;  
      DECLARE toy_id INT; 
      DECLARE toy_desc VARCHAR(255);  
      DECLARE cur CURSOR FOR SELECT id, description FROM toys WHERE name = toy_name;  
      DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;    
      OPEN cur;    
          read_loop: LOOP    
                FETCH cur INTO toy_id, toy_desc;    
                IF done THEN      
                      LEAVE read_loop;    
                END IF;        
                SELECT CONCAT('Toy ID: ', toy_id, ', Description: ', toy_desc) AS details;  
          END LOOP;    
  CLOSE cur;
END;
demiliter $

调用时 call show_toy_details (‘玩具名称')