Re: turn off auto commit in MYSQL

2002-11-14 Thread Peter Brawley
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, Nov

RE: turn off auto commit in MYSQL

2002-11-14 Thread Natale Babbo
> > > -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 >

RE: turn off auto commit in MYSQL

2002-11-14 Thread Devi Annisetty
-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

turn off auto commit in MYSQL

2002-11-13 Thread Devi Annisetty
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 Dev