Hello Oliver, Thanks for the suggestion but that was not what I am looking for. I know about the command SET AUTOCOMMIT=0 but that is a session level solution.
I want transactions to be on always on the database for every session. i.e. the default to 0 rather than the default of 1 as it is now. I have looked high and low but I can only find reference to the default setting of mysql autocommit being 1 and no reference on how to change that default. Thanks, Serge. ----- Original Message ----- From: "Oliver Vecernik" <[EMAIL PROTECTED]> To: "Serge Paquin" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, June 12, 2002 1:59 AM Subject: Re: Autocommit > Serge Paquin wrote: > > Hello, > > > > I am setting up mysqld-max with InnoDB Tables. How can I set autocommit to off? I want this a global option for the DBMS. > > Did you read the docs? There is even an example (chapter 7.5.8.6). > > Oliver > --------------------------------------------------------------------- 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