Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
DELIMITER // CREATE PROCEDURE GetOrderStats( IN cust_id INT, OUT total_orders INT, OUT total_spent DECIMAL(10,2) ) BEGIN SELECT COUNT(*), SUM(total) INTO total_orders, total_spent FROM orders WHERE customer_id = cust_id; END // DELIMITER ; CALL GetOrderStats(5, @cnt, @spent); SELECT @cnt AS orders, @spent AS spent;
Result
Open