Is there recursive store procedures in MySql?

Question

I want to know if is there recursive procedures in MySql and how can I implement them

Answer 1

By default, recursion is disabled because it does affect things like required thread stack space in the server and so on. You can allow recursion by setting the max_sp_recursion_depth server variable, but I would highly discourage it.