-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
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
Hi,
I have table called Media_table which has column Media_type. The data
for Media type can be any of the Movie,Trailer,Flash,Music
etc(almost fixed, not expected to change in near future,Or even if it
changes also very minor updations very rarely).
I thinking of two possibilities here
1.
Hi
I need to insert the same auto increment value in 2 different tables
simultaneously.
I am new to the MySQL.Is there any function which helps for this type of
manipulations?
Or I need to store the value in host variable and update the tables with
this host variable?
Greatly appreciate you