List:MySQL on Win32« Previous MessageNext Message »
From:Jorge Bastos Date:June 22 2006 12:44pm
Subject:Fw: Turning Auto-Commit off in InnoDB
View as plain text  
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=1
>
> 

Thread
Fw: Turning Auto-Commit off in InnoDBJorge Bastos22 Jun