is there any configuration that turn on auto commit persistently ... i mean for each client connections? (in my.cnf [client] or something else)
Thanks in advance. Natale Babbo --- Devi Annisetty <[EMAIL PROTECTED]> ha scritto: > Hi Peter, > > 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 > > > > > > --------------------------------------------------------------------- > 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 > ______________________________________________________________________ Per te Blu American Express è gratis! http://it.yahoo.com/mail_it/foot/?http://www.americanexpress.it/land_yahoo --------------------------------------------------------------------- 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