MySQL Stored Procedures and Functions
Topics
- Stored routines
- Stored procedures
- IN, OUT, INOUT parameters
- Stored functions
- Built-in functions
- Optional clauses
- Variables
- IF and CASE
- LOOP/WHILE/REPEAT
- CURSOR
- Handlers
Stored Routines
What is a Stored Routine?
- Captures a block of SQL statements in reusable and callable logic
- Associated with a specific database
- Two different kinds of stored routines
- Stored procedures
- Stored functions
Download course content