Example

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

CALL GetHighSalary();