What is a stored procedure in MySQL

A stored procedure in MySQL is a set of SQL statements that can be stored in the database and executed as a single unit. This allows for better organization, reusability of code, and can improve performance by reducing the amount of data sent between the application and the database. Stored procedures can accept parameters, perform complex operations, and return results to the caller, making them a powerful tool for database management and application development.

Example of a Stored Procedure


        DELIMITER //
        CREATE PROCEDURE GetEmployeeByID(IN emp_id INT)
        BEGIN
            SELECT * FROM employees WHERE employee_id = emp_id;
        END //
        DELIMITER ;