CREATE FUNCTION
Learn CREATE FUNCTION (Stored Functions, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction A stored function is a named routine that takes parameters, RETURNS exactly one scalar value, and can be used inside any expression, such as SELECT , WHERE or ORDER BY . Unlike procedures, you do not CALL it.