MySQL Workbench: Data Modeling & Development

CHAPTER

5

Creating and Managing Routines

outines are stored programs. Specifically, they’re stored functions or procedures. There are three differences between functions and procedures in MySQL. Functions only take input or pass-by-value parameters, whereas procedures take input, input and output, and output-only parameters (any parameter with an output mode is a pass-by-reference parameter). Functions return a value and can be used inside queries or as right operands in assignments, but procedures can’t do either. Procedures can contain INSERT, ...