MySQL variables

Note to self when working with MySQL variables:

@@GLOBAL.var = global level server variable
@@SESSION.var = session level global variable

@var = user defined variable
@@var = session level server variable if it exists – otherwise global level server value… so be sure you understand what you are getting/setting when you use it.