This time, I will make a closer look at mysql user variables. They can be divided into two main categories: defined variables, used in procedures and functions and undefined, also can be used in procedures and function, but also can be used in sql queries as in-line code.