Skip to main content

IN, OUT & INOUT Parameters

Learn IN, OUT & INOUT Parameters (Stored Procedures, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction Procedure parameters have a direction. IN (default) passes a value in. OUT sends a value back; its starting value inside is NULL. INOUT goes in, can be changed, and comes back. Callers receive OUT and INOUT values through user variables such as @total .

More lessons in Stored Procedures