Re: set autocommit

[Paul DuBois]

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
thanks
Just one.

--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]