Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
DELIMITER // CREATE PROCEDURE ProcessPendingOrders() BEGIN DECLARE v_done INT DEFAULT 0; DECLARE v_order_id INT; DECLARE cur CURSOR FOR SELECT id FROM orders WHERE status = 'pending'; DECLARE CONTINUE HANDLER FOR NOT FOUND SET v_done = 1; OPEN cur; read_loop: LOOP FETCH cur INTO v_order_id; IF v_done THEN LEAVE read_loop; END IF; CALL ApplyDiscount(v_order_id); END LOOP; CLOSE cur; END // DELIMITER ;
Result
Open