Module 3
MySQL Stored Procedures, Functions & Triggers
25 mins read
Lesson 1: Stored Procedures
1.1 Creating & Executing Stored Procedures
Stored procedures encapsulate database logic on the MySQL server, reducing network round-trips and protecting queries.
MYSQL
DELIMITER //
CREATE PROCEDURE GetEmployeeDetails(IN emp_id INT)
BEGIN
SELECT * FROM employees WHERE employee_id = emp_id;
END //
DELIMITER ;