Stored Procedures

Stored procedures are reusable SQL code blocks that improve efficiency and security.

Example: Creating a Stored Procedure

DELIMITER $$
CREATE PROCEDURE GetEmployees()
BEGIN
    SELECT * FROM employees;
END $$
DELIMITER;

Example: Executing a Stored Procedure

CALL GetEmployees();