----- Original Message -----
> From: "Reindl Harald" <h.rei...@thelounge.net>
> 
> DO NOT REPLY OFF-LIST

Also, do not shout :-)

> the difference is "set" or "set global"

Same for show, and 'show variables' is implicitly the same as the clearer 'show 
session variables'.

> global is what would be used if the thread does not change it

That is, at connect time all the session variables are initialized from the 
global variables; and the session can then override them.

For status variables (like com_*), the globals are cumulative counters, while 
the session ones are this-session counters.


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql

Reply via email to