DO NOT REPLY OFF-LIST
i do not understand what is unclear
you can set variables per sql and my.cnf
most of them, not all
the difference is "set" or "set global"
global is what would be used if the thread does not change it
the same as in php set a value per "php.ini" or ".htaccess"
Am 30.11.2011 11:28, schrieb Stdranwl:
> Thnx... So does it mean that global value is accumulative values and it is the
> of the value which can be assigned.?
> On Wed, Nov 30, 2011 at 3:53 PM, Reindl Harald <h.reindl@stripped
> <mailto:h.reindl@stripped>> wrote:
> Am 30.11.2011 11:04, schrieb Stdranwl:
> > Hi
> > I can see different values when I run show global variables like
> > ............. && show variables like .........? could any body
> > revert me on the scope and how they works?
> a global variable is global and for all threads
> set without global is only for the current connection
Mit besten Grüßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc