Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
DELIMITER // CREATE PROCEDURE GetCustomerOrders(IN cust_id INT) BEGIN SELECT o.order_id, o.created_at, o.total FROM orders o WHERE o.customer_id = cust_id ORDER BY o.created_at DESC; END // DELIMITER ; -- Call the procedure CALL GetCustomerOrders(42);
Result
Open