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

In this issue, the editor will bring you about the variable assignment in mysql. The article is rich in content and analyzed and described from a professional point of view. I hope you can get something after reading this article.

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.

However, I did not expect that the assignment of multiple variables is to write multiple declare, which is very difficult to understand and different from oracle.

Such as:

Mysql:

Declare v_1 int default 0

Declare v_2 int default 0

It cannot be written as:

Declare

V_1 int default 0

V_2 int default 0

This is what the variable assignment in mysql is like. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

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.