Creating Stored Procedures and Functions in MySQL

Stored Procedure

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

Stored Function

CREATE FUNCTION TaxAmount(salary DECIMAL(10,2))
RETURNS DECIMAL(10,2)
RETURN salary * 0.1;