MySQL - Parâmetros IN, OUT e INOUT em Procedimentos Armazenados - 36

Summary

This video by Fábio from Boson Treinamentos provides a detailed exploration of the three types of parameters used in MySQL stored procedures: `IN`, `OUT`, and `INOUT`. It explains the purpose and behavior of each parameter type, emphasizing their differences in terms of value passing and modification within the stored procedure. Through practical examples, viewers learn how to declare, pass, and manipulate parameters, with a focus on real-world applications. This tutorial is perfect for anyone looking to deepen their understanding of stored procedures in MySQL and how parameters play a key role in database management.

Takeaways

• 😀 The script explains the use of parameters in stored procedures in MySQL, specifically focusing on three types: IN, OUT, and INOUT.
• 😀 IN parameters are the default type in MySQL stored procedures, where the value passed to the procedure remains unchanged outside of it.
• 😀 OUT parameters allow values to be altered within the procedure, and the modified value is passed back to the calling program.
• 😀 OUT parameters are initialized to NULL before the procedure begins, meaning the procedure cannot access the original value.
• 😀 INOUT parameters combine both IN and OUT functionality, where the value is passed into the procedure and can be modified, with the modified value returned to the caller.
• 😀 The default parameter type in MySQL stored procedures is IN, meaning you don't have to explicitly declare it when creating a procedure.
• 😀 A key difference between IN and OUT parameters is that IN parameters are passed by value (not modifying the original value), while OUT parameters are passed by reference (modifying the original value).
• 😀 When creating a stored procedure, you declare the parameter type, name, and, if applicable, its size, specifying the mode as IN, OUT, or INOUT.
• 😀 The example of an IN parameter is demonstrated with a procedure that retrieves book details based on the publisher's name, showing how the value remains unchanged outside the procedure.
• 😀 OUT parameters are demonstrated by a procedure that takes an ID, retrieves the corresponding book name, and returns it using the OUT parameter, altering the value in the calling program.
• 😀 The script illustrates the use of INOUT parameters with a procedure that adjusts a book's price based on a percentage increase, demonstrating how the passed value is altered and returned.

The video is abnormal, and we are working hard to fix it.
Please replace the link and try again.