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 ;-) So to come back to your question, you will need only 1 line SET AUTOCOMMIT = 1 to activate the AUTOCOMMIT function. Best regards Nils Valentin Tokyo/Japan 2003年 6月 30日 月曜日 15:21、artem さんは書きました: > 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 -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
