From: Martijn Tonies
Date: April 2 2012 10:24am
Subject: List of global/session variables (@myvar)
List-Archive: http://lists.mysql.com/mysql/227082
Message-Id: <36a001cd10ba$c3d94510$1601a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit

Hi,

Is there a way to get the currently available global variables
that are defined by, for example, a Stored Procedure that
returns stuff as 

set @myvar = 'result';

when outside the stored procedure?

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!