那帮我看看这一段什么问题吧,为什么注释掉 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
REPEAT FETCH c_products INTO v_products_id, v_products_name; set v_products_name=REPLACE(v_products_name, '2003', '2010'); SELECT v_products_name; UNTIL no_more 楼主需要学习一下语法基础。
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
select REPLACE(v_products_name, '2003', '2010');
FETCH c_products INTO v_products_id, v_products_name;
set v_products_name=REPLACE(v_products_name, '2003', '2010');
SELECT v_products_name;
UNTIL no_more
楼主需要学习一下语法基础。