Set and create user variable : Variable Declaration « Procedure Function « SQL / MySQL

1. SQL / MySQL
2. Procedure Function
3. Variable Declaration

Set and create user variable

     

delimiter $$

CREATE PROCEDURE USER_VARIABLE ()
BEGIN
   SET @VAR1 = 1;
END$$

delimiter ;

CALL USER_VARIABLE ()
;
SELECT @VAR1;

   
    
    
    
    
  

Related examples in the same category