O'Reilly logo

MySQL Workbench: Data Modeling & Development by Michael McLaughlin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

image
CHAPTER
5
Creating and Managing Routines
imageoutines 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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required