MySQL: User-Defined Variables in SQL Queries

This time my interest fell specifically on user-defined variables. They can be broadly divided into two categories: declared variables, used in procedures and functions, and undeclared variables, also used in procedures and functions, but which can be used in an SQL query "in-line".