Fw: Turning Auto-Commit off in InnoDB

i think you can do that in my.cnf

set-variable autocommit=0

----- Original Message -----
From: "Asif Lodhi"
To:
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 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@decimal.pt
>
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org