How to Assign a Value to a Variable in MySQL. MySQL user-defined variables are used to pass values from one statement to another. They are connection specific.

To access a variable’s value, specify the variable’s name (for primitive types and String), de-reference the object and access a member, or use an array-index notation to identify the element ...