From: Jorge Bastos
Date: June 22 2006 12:44pm
Subject: Fw: Turning Auto-Commit off in InnoDB
List-Archive: http://lists.mysql.com/win32/18383
Message-Id: <01a201c695f9$9c4c28b0$0301a8c0@hercules.decimalint.pt>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=response
Content-Transfer-Encoding: 7bit

i think you can do that in my.cnf

set-variable autocommit=0

----- Original Message ----- 
From: "Asif Lodhi" <itmailster@stripped>
To: <win32@stripped>
Sent: Thursday, June 22, 2006 11:57 AM
Subject: Re: Turning Auto-Commit off in InnoDB


> Hi,
>
> I am replying to my own query again - to explain my problem:  I want
> to know if there is a system variable to turn off AUTOCOMMIT in the
> options file instead of using "SET AUTOCOMMIT=0" in SQL code.
>
> Any help?
>
> --
> Asif
>
>
> On 6/22/06, Asif Lodhi <itmailster@stripped> wrote:
>> Hi,
>>
>> I read that autocommit (after every SQL insert/update/delete) is on by
>> default in InnoDB.  I would rather commit after multiple SQL
>> inserts/updates/deletes.  Is there anyway I can do this?
>>
>> Thanks in advance.
>>
>> --
>> Asif
>>
>
> -- 
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: 
> http://lists.mysql.com/win32?unsub=mysql.jorge@stripped
>
>