The following discussion first discusses how MySQL handles improper data by default, and then covers the changes that occur when you enable the various SQL modes that affect data handling.

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.