存储过程要在数据库上创建的, 用create procedure proc_name() begin 语句 end 给你一个网址 http://www.bc-cn.net/Article/Search.asp?Field=Title&ClassID=&keyword=%B4%E6%B4%A2%B9%FD%B3%CC&Submit=+%CB%D1%CB%F7+
CREATE PROCEDURE curdemo(out c text) BEGIN DECLARE done INT DEFAULT 0; DECLARE a CHAR(16); DECLARE cur1 CURSOR FOR SELECT data FROM test.t1; DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;OPEN cur1;REPEAT FETCH cur1 INTO a; set c = c+a+'#'; UNTIL done END REPEAT;CLOSE cur1; END
用create procedure proc_name()
begin
语句
end
给你一个网址
http://www.bc-cn.net/Article/Search.asp?Field=Title&ClassID=&keyword=%B4%E6%B4%A2%B9%FD%B3%CC&Submit=+%CB%D1%CB%F7+
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE a CHAR(16);
DECLARE cur1 CURSOR FOR SELECT data FROM test.t1;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;OPEN cur1;REPEAT
FETCH cur1 INTO a;
set c = c+a+'#';
UNTIL done END REPEAT;CLOSE cur1;
END