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

You must have an active subscription to download PDF,Lab Zip and Recordings of this course topic.Please click the "Subscribe" button or the "Login" button if you already have an account.