Loosing MySQL variable (@var)
Posted: Tue Jan 26, 2010 2:54 pm
How should I organize my queries to keep a MySQLs variable through multiple queries?
The value of my @varname turns to null between queries.
I LOCK the table
do a couple of queries (with the need of a persistant @varname)
UNLOCK the table
Is this normal MySQL behaivor or am I missing something?
The value of my @varname turns to null between queries.
I LOCK the table
do a couple of queries (with the need of a persistant @varname)
UNLOCK the table
Is this normal MySQL behaivor or am I missing something?