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
