delimiter //
drop FUNCTION if exists tests//
create FUNCTION tests() RETURNS varchar(30)
BEGIN
declare st1 VARCHAR(30) default '0';
declare st2 VARCHAR(30) default '0';
declare st3 VARCHAR(30) default '0';
declare cursor1 cursor for select address,city from persons;
FETCH next from cursor1 into st2,st3;
while @@FETCH_STATUS = 0 DO
SET st1 = CONCAT (st2,st3);
end while;
close cursor1; RETURN st1;
END //
deallocate cursor1;
delimiter ;
#运行提示unknown system variable FETCH_STATUS
#以上是mysql语句!
drop FUNCTION if exists tests//
create FUNCTION tests() RETURNS varchar(30)
BEGIN
declare st1 VARCHAR(30) default '0';
declare st2 VARCHAR(30) default '0';
declare st3 VARCHAR(30) default '0';
declare cursor1 cursor for select address,city from persons;
FETCH next from cursor1 into st2,st3;
while @@FETCH_STATUS = 0 DO
SET st1 = CONCAT (st2,st3);
end while;
close cursor1; RETURN st1;
END //
deallocate cursor1;
delimiter ;
#运行提示unknown system variable FETCH_STATUS
#以上是mysql语句!
解决方案 »
- 去重问题, 如何筛选出1小时内的重复数据
- mysql5.5版本如何记录update类型的语句日志
- mysql中文乱码??(mysql+php)在线等,急
- 一个触发器问题 MYSQL
- 一个关于时间查询的问题
- 怎样在txt文档用教本建数据库和N张表?
- 50分求php在mysql下的分页函数
- 我装的mysql-5.0.0a-alpha,为什么看不到mysql这个database,只有test一个?
- (散发)火大!!!!!!!!烦人的 Too many connections
- 如图:安装Mysql时为什么会出现配置文件的模板:E:\MYSQL\my-template.ini 无法处理,并写入到E:\MYSQL\my.ini.中
- 如何提升数据更新效率?
- sql 优化
CREATE PROCEDURE curdemo()
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE a CHAR(16);
DECLARE b,c INT;
DECLARE cur1 CURSOR FOR SELECT id,data FROM test.t1;
DECLARE cur2 CURSOR FOR SELECT i FROM test.t2;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1; OPEN cur1;
OPEN cur2; REPEAT
FETCH cur1 INTO a, b;
FETCH cur2 INTO c;
IF NOT done THEN
IF b < c THEN
INSERT INTO test.t3 VALUES (a,b);
ELSE
INSERT INTO test.t3 VALUES (a,c);
END IF;
END IF;
UNTIL done END REPEAT; CLOSE cur1;
CLOSE cur2;
END