Chapter-20 : How to declare variable in Stored Procedure in SQL with example | MySQL database

How to declare variable in Stored Procedure in SQL

To declare a variable in a stored procedure in SQL, you use the DECLARE statement. The DECLARE statement specifies the name of the variable, its data type, and its initial value.
Variables can be used to store temporary values, such as the results of a query or the parameters passed to the procedure.
Accumulating values: Variables can be used to accumulate values, such as the number of rows returned by a query or the total value of orders placed by a customer.
Controlling the flow of the procedure: Variables can be used to control the flow of the procedure, such as by looping through a set of data or by branching to a different section of the procedure based on the value of a variable.
Variables are a powerful tool for developing and maintaining stored procedures. They can be used to simplify complex logic, improve performance, and make stored procedures more robust.