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.