i think you can do that in my.cnf
set-variable autocommit=0
----- Original Message -----
From: "Asif Lodhi" <itmailster [at] gmail.com>
To: <win32 [at] lists.mysql.com>
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 [at] gmail.com> 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 [at] decimal.pt
>
>
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32 [at] m.gmane.org
