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"" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php