May 2013
Intermediate to advanced
480 pages
9h 38m
English

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, ...