56,675
社区成员
发帖
与我相关
我的任务
分享
REPLACE(v_products_name, '2003', '2010');
BEGIN
#Routine body goes here...
DECLARE no_more INT DEFAULT 0;
DECLARE v_products_name VARCHAR(150);
DECLARE v_products_id int;
DECLARE c_products CURSOR FOR SELECT products_id, products_name FROM products_description;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET no_more = 1;
OPEN c_products;
REPEAT
FETCH c_products INTO v_products_id, v_products_name;
REPLACE(v_products_name, '2003', '2010');
SELECT v_products_name;
UNTIL no_more
END REPEAT;
CLOSE c_products;
END