Re: how to set autocommit

["Heikki Tuuri" <Heikki.Tuuri@xxxxxxxxxx>]

Ben,

I have added the following item to the TODO list of September 2002. I guess
it will appear only in the MySQL-4.0 branch, as 4.0 will be the new stable
branch within a few months.

...
September, 2002:
Add a global MySQL my.cnf option autocommit_default=0.
...

Best regards,

Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com

----- Original Message -----
From: ""Ben Goswami"" <bengoswami@xxxxxxxxx>
Newsgroups: mailing.database.mysql
Sent: Monday, July 29, 2002 7:52 AM
Subject: how to set autocommit


> Hi,
> Where should I change the autocommit setting to 0 (i.e no Autocommit).
I'm
> inserting row from perl script using DBI. I would like to bring up mySQL
> server with autocommit false, so that I can explicitly commit from the
front
> end.  But with lot of research in various docs I could not find where to
> changer the settings.  If I supply it in the connect string, it does not
> take it.
> Any help is appreciated
>
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread115767@xxxxxxxxxxxxxxx>
> To unsubscribe, e-mail
<mysql-unsubscribe-mysql=freebsd.csie.nctu.edu.tw@xxxxxxxxxxxxxxx>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread115771@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php