Using Variables

Variables allow you to store and manipulate data within your procedures. In MySQL, variables must be declared and their data types specified before use. Using a distinct prefix (such as v_) for variable names is a recommended practice to avoid conflicts with column names and to enhance code clarity.

drop procedure if exists sp_DBR_variables
$$
create procedure sp_DBR_variables()
begin

declare v_value integer;
declare v_date date;

set v_value = 1;
set v_date = now();

select v_value as 'Value', v_date as 'Date';

end
$$  

call sp_DBR_variables();
+-------+------------+
| Value | Date       |
+-------+------------+
|     1 | 2015-03-27 |
+-------+------------+
1 row in set (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)