mysql update的存储过程

其实存储过程和函数真的很像，我感觉调试没有函数好，最近写了个简单的存储过程，是为了简单的对不同范围的值进行update的操作， CREATE PROCEDURE set_class(in class_value int,in mix_value int,in max_value INT) BEGIN

DECLARE idd int; – DECLARE class int ;

DECLARE done int;

DECLARE se_cursor CURSOR FOR SELECT id FROM retailstore_m_product; DECLARE CONTINUE HANDLER FOR NOT FOUND SET done=1;

OPEN se_cursor; cursor_loop:LOOP

FETCH se_cursor INTO idd;

if done = 1 THEN LEAVE cursor_loop; end if; if idd BETWEEN mix_value and max_value THEN UPDATE retailstore_m_product set class = class_value WHERE id=idd; end if; end LOOP cursor_loop; CLOSE se_cursor;

END