Turning Auto-Commit off in InnoDB

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=gcdmw-win32@m.gmane.org

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=gcdmw-win32@m.gmane.org