Shulou(Shulou.com)05/31 Report--

How to understand MySQL ECLARE local variables, I believe that many inexperienced people do not know what to do. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

I didn't expect that the variables in mysql would be in BEGIN. In END, I always thought that before begin, I was depressed.

1. DECLARE local variable DECLARE var_name [,...] Type [DEFAULT value]

This statement is used to declare local variables. To provide a default value for a variable, include a DEFAULT clause. Value can be specified as an expression and does not need to be a constant. If there is no DEFAULT clause, the initial value is NULL.

The scope of a local variable is in the BEGIN where it is declared. Within the END block. It can be used in nested blocks, except for those that declare variables with the same name.

After reading the above, have you mastered how to understand MySQL ECLARE local variables? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.