Creating and Using Stored Procedures in MySQL

Example

DELIMITER //
CREATE PROCEDURE GetHighSalary()
BEGIN
  SELECT * FROM employees WHERE salary > 100000;
END //
DELIMITER ;

CALL GetHighSalary();