This is what I think. When Autocommit is set you DO NOT have to enter COMMIT after you update your DB (Update, Insert Delete), but you will be changing the DB after every statement, therefore you cannot change your mind after the command is execute.
Now as for BEGIN, it will begin a Transaction regardless of the Autocommit value. Therefore if you have Autocommit set, but you do: BEGIN; SQLCOMMANDS; COMMIT OR ROLLBACK; The changes will be save only at the COMMIT or if you do not want the changes to take effect you can ROLLBACK. When Autocommit is not set you MUST COMMIT after your SQL statement in order for the changes to be written into the DB regardless as to you start or not with BEGIN. HTH JFernando *** sql *** -----Original Message----- From: Peter Brawley [mailto:peter.brawley@;artfulsoftware.com] Sent: October 30, 2002 12:38 To: Dyego Souza do Carmo; Egor Egorov Cc: [EMAIL PROTECTED] Subject: Re: Re[2]: Start Transaction in InnoDB Dyego, BEGIN, not set begin. My understanding is that BEGIN is a synonym for SET autocommit=0. PB ----- > AB>> I would like to know, how can I start a new transaction using InnoDB Tables? > > EE> Use BEGIN statement: > EE> http://www.mysql.com/doc/en/COMMIT.html > > EE> Don't forget to SET AUTOCOMMIT=0; > > > What is the diference of SET AUTOCOMMIT=0; > > and set BEGIN; ? > > If I start the transaction with "BEGIN" and without "SET AUTOCOMMIT=0" what will happen ? > > what is the diference ? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
