Philip, Jani promised that in February 2003 you can set autocommit=0 globally in my.cnf.
I am carbon copying this to Jani. The feature is widely requested. Regards, Heikki .................... Subject: Disable autocommit by default From: Philip Molter Date: Thu, 16 Jan 2003 15:41:47 -0600 ---------------------------------------------------------------------------- ---- I want to disable autocommit for all command-line client connections by default (through the mysql> prompt). I believe I can do this in the [client] section of the my.cnf config file, but I have no clue how. Three questions: 1) How? 2) Will it affect other client processes, such as those spawned by perl through DBD::mysql? 3) Is there a list of all the possible config options for the my.cnf file somewhere? Thanks, Philip sql, mysql * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] --------------------------------------------------------------------- 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