Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
DELIMITER // CREATE PROCEDURE ApplyDiscount(IN order_id INT) BEGIN DECLARE v_total DECIMAL(10,2); DECLARE v_discount DECIMAL(5,2) DEFAULT 0.00; SELECT total INTO v_total FROM orders WHERE id = order_id; IF v_total > 500 THEN SET v_discount = 0.15; ELSEIF v_total > 200 THEN SET v_discount = 0.10; ELSE SET v_discount = 0.05; END IF; UPDATE orders SET discount = v_discount WHERE id = order_id; END // DELIMITER ;
Result
Open