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