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.
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.