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