mysql函数程序调用,MySQL函数调用

If I call a function several time then will it execute every time or just execute once and the value will be used then after several time?

Example:

select my_function('filed'),my_function('filed')/field2,

(my_function('filed')*field1)/field3,

...... from my_table where group by filed1;

My question is my_function('filed') will be executed once and then the result will be used in my_function('filed')/field2 and (my_function('filed')*field1)/field3 or every time my_function('filed') will be called and executed in system level ?

解决方案

Why not use a variable that catch the value of your function.

For example:

declare var_function (datatype(size)); // just to declare proper data type for your function

set var_function = my_function('filed');

select var_function, var_function/field2,

(var_function*field1)/field3,

....from my_table where group by filed1;

in that case, you'll be going to reuse the function result and no need to repeat the process of the function.