검색결과 리스트
cursor에 해당되는 글 1건
- 2014.10.16 [MySQL] MySQL Cursor
글
링크: http://dev.mysql.com/doc/refman/5.5/en/cursors.html
CREATE PROCEDURE curdemo()
BEGIN
DECLARE done INT DEFAULT FALSE;
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 = TRUE;
OPEN cur1;
OPEN cur2;
read_loop: LOOP
FETCH cur1 INTO a, b;
FETCH cur2 INTO c;
IF done THEN
LEAVE read_loop;
END IF;
IF b < c THEN
INSERT INTO test.t3 VALUES (a,b);
ELSE
INSERT INTO test.t3 VALUES (a,c);
END IF;
END LOOP;
CLOSE cur1;
CLOSE cur2;
END;
'DB / NoSQL > MariaDB/MySQL' 카테고리의 다른 글
[MySQL] Host 'xxx.xxx.xxx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' (0) | 2014.11.15 |
---|---|
[MySQL] 13.5 SQL Syntax for Prepared Statements (0) | 2014.10.16 |
[Mysql] Function, Procecure dump (0) | 2014.08.06 |
[MySQL] Update Join (0) | 2014.07.30 |
[MySQL] Workbench의 Update Delete시 Error Code 1175 (0) | 2014.05.19 |
RECENT COMMENT