Fw: Turning Auto-Commit off in InnoDB
"Jorge Bastos" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
i think you can do that in my.cnf set-variable autocommit=0 ----- Original Message ----- From: "Asif Lodhi" <[email protected]> To: <[email protected]> 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 <[email protected]> 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/[email protected] > > -- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/[email protected]