其实存储过程和函数真的很像,我感觉调试没有函数好,最近写了个简单的存储过程,是为了简单的对不同范围的值进行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