artem wrote:
please clarify use of set autocommit
Here's an unsolicited opinion: AVOID using autocommit within
applications. Based on my experiences with other DBMSs, it's a very
likely source of hard-to-find program bugs. The problem occurs when
it's turned on and off in a program -- it's
At 9:21 +0300 6/30/03, artem wrote:
please clarify use of set autocommit
SET AUTOCOMMIT = 0 ==> mean start transaction
... - some actions
COMMIT ==> transaction end
now to return to autocommit mode
just one line:
SET AUTOCOMMIT = 1
or two?
SET AUTOCOMMIT = 1
COMMIT
than
Hi Artem,
I understood the AUTOCOMMIT command different.
SET AUTOCOMMIT = 0 ==> deactivate AUTOCOMMIT
SET AUTOCOMMIT = 1 ==> activate AUTOCOMMIT
The commands
BEGIN
. some instructions
COMMIT
are used to start or finish a transaction.
Anybody, please correct me if I talk rubbish ;-
