i think you can do that in my.cnf
----- Original Message -----
From: "Asif Lodhi" <itmailster@stripped>
Sent: Thursday, June 22, 2006 11:57 AM
Subject: Re: Turning Auto-Commit off in InnoDB
> 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?
> On 6/22/06, Asif Lodhi <itmailster@stripped> wrote:
>> 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.
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
|• Fw: Turning Auto-Commit off in InnoDB||Jorge Bastos||22 Jun|