Please enable JavaScript.

Coggle requires JavaScript to display documents.

Store procedure - Coggle Diagram

- - - - CLOSE cur2;
      - CLOSE cur1;
      - END LOOP;
      - read_loop: LOOP
        
        END IF;
        
        ELSE
        
        INSERT INTO test.t3 VALUES (a,c);
        
        IF b < c THEN
        
        INSERT INTO test.t3 VALUES (a,b);
        
        END IF;
        
        IF done THEN
        
        LEAVE read_loop;
        
        FETCH cur2 INTO c;
        
        FETCH cur1 INTO a, b;
      - OPEN cur2;
      - OPEN cur1;
      - DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
      - DECLARE cur2 CURSOR FOR SELECT i FROM test.t2;
      - DECLARE cur1 CURSOR FOR SELECT id,data FROM test.t1;
  - - - skip lock
        
        trả về những hàng ko bị lock
      - NOWAIT
        
        trả lỗi nếu hàng đang đợi
    - - giống update
        
        chặn ko cho th khác cập nhật hàng đó
  - - - transaction
    - - non-transaction
        
        error
        
        tcc110_batchrslt