Try this from the manual,
http://dev.mysql.com/doc/mysql/en/Server_system_variables.html.
....
init_connect
A string to be executed by the server for each client that connects. The
string consists of one or more SQL statements. To specify multiple
statements, separate them by semicolon characters. For example, each client
begins by default with autocommit mode enabled. There is no global server
variable to specify that autocommit should be disabled by default, but
init_connect can be used to achieve the same effect:
SET GLOBAL init_connect='SET AUTOCOMMIT=0';
This variable can also be set on the command line or in an option file.
To set the variable as just shown using an option file, include these lines:
[mysqld]
init_connect='SET AUTOCOMMIT=0'
This variable was added in MySQL 4.1.2.
.....
-----Original Message-----
From: Terence
To: [EMAIL PROTECTED]
Sent: 7/21/04 4:20 AM
Subject: Disable the autocommit
According to:
http://dev.mysql.com/doc/mysql/en/COMMIT.html
>With START TRANSACTION, autocommit remains disabled until you end the
>transaction with COMMIT or ROLLBACK. The autocommit mode then reverts
>to its previous state.
Is there anyway to disable the revert? I don't want to have to SET
@@AUTOCOMMIT=0; after each commit.
Thanks for any help!
Regards
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
