> is there any configuration that turn on auto commit > persistently ... i mean for each client connections? > (in my.cnf [client] or something else)
The default is ON. Turning it off is how a client begins a transaction. If you want to prevent users from using transactions, you can use MyISAM tables. PB ----- > > > > Thank you very much > > I got one more question > > Do I need to change the table type to > > transaction-safe tables (InnoDB > > and BDB) ? > > AS I am going thru the manuals I read that tables > > should be of InnoDB > > or BDB inorder to work for manual commit. > > > > > > once again thanks in advance, > > Devi > > > > > > -----Original Message----- > > From: Peter Brawley > > [mailto:peter.brawley@;artfulsoftware.com] > > Sent: Wednesday, November 13, 2002 6:04 PM > > To: Devi Annisetty > > Subject: Re: turn off auto commit in MYSQL > > > > > > SET @@autocommit=0 > > or > > BEGIN > > > > ----- > > > > Hi, > > I am newbie to MYSQL and ODBC > > > > I have to update more than 2 tables simultanously > > currently my application uses ADOBC connection > > object. > > > > How can turn off the autocommit option and set > > manaul commit. > > > > what places I need to change inorder to work manual > > commit > > > > Thanks in Advance for your time > > Devi --------------------------------------------------------------------- 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
