Deterministic Functions
Learn Deterministic Functions (Stored Functions, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction A function is DETERMINISTIC if the same inputs always give the same output. You declare it with the keyword; MySQL trusts the declaration and does not verify it. Alternatives are NOT DETERMINISTIC (default), plus data-access hints NO SQL , READS SQL DATA , MODIFIES SQL DATA .