gt;
To: "Visolve DB Team" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, November 22, 2006 10:59 AM
Subject: Re: AUTOCOMMIT. displaying and setting
> Thanks!
> I played a bit init_connect. I'm not sure though how can I verify the
> autocommit value. You say 'by
Thanks!
I played a bit init_connect. I'm not sure though how can I verify the
autocommit value. You say 'by select'. Something like this?
select @@AUTOCOMMIT;
Because that still gives me a value of '1'.
More important to me: Can this variable be set per-connection? If so,
how? Specifically, how
There is no global system variable to set Autocommit; but we can achieve the
same with 'init_connect=SET AUTOCOMMIT=0'.
This variable can be set from the mysql or in the commandline or in the
option file.
Like,
mysql > SET GLOBAL init_connect='SET AUTOCOMMIT=0';
or
mysql>SET @@GLOBAL.init_connect=
