Stored Procedures

Stored procedures are precompiled SQL scripts that can be executed with parameters to automate tasks.

CREATE PROCEDURE GetCustomerOrders (IN customer_id INT)
BEGIN
    SELECT * FROM orders WHERE customer_id = customer_id;
END;