Mysql - Recursive stored procedure, Mysql max_sp_recursion_depth variable

Recursive stored procedure

To execute recursive stored procedure in mysql, set the value for the mysql variable max_sp_recursion_depth to greater than zero or upto the number of recursions needed for your stored procedure.
The maximum value for max_sp_recursion_depth is 255.

Mysql Command to see mysql variable

  SHOW VARIABLES;

Mysql Command to find max_sp_recursion_depth

  SHOW VARIABLES LIKE '%recursion%';

Syntax to set Mysql variable

  SET @var_name = expr;

The topic on Mysql - Recursive stored procedure is posted by - Maha

Hope you have enjoyed, Mysql - Recursive stored procedureThanks for your time