Re: Turning Auto-Commit off in InnoDB
"Asif Lodhi" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
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]