Start Transaction in InnoDB

2002-10-30 Thread Alexander Burbello
Hi, I would like to know, how can I start a new transaction using InnoDB Tables? Alexander mysql, query ___ Yahoo! Encontros O lugar certo para encontrar a sua alma gêmea. http://br.encontros.yahoo.com/

Re: Start Transaction in InnoDB

2002-10-30 Thread Dyego Souza do Carmo
To request this thread, e-mail [EMAIL PROTECTED] AB To unsubscribe, e-mail [EMAIL PROTECTED] AB Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php In InnoDB you start a transaction with: BEGIN; INSERT. UPDATE COMMIT; The BEGIN command init a transaction... The COMMIT

re: Start Transaction in InnoDB

2002-10-30 Thread Egor Egorov
Alexander, Wednesday, October 30, 2002, 1:40:11 PM, you wrote: AB I would like to know, how can I start a new transaction using InnoDB Tables? Use BEGIN statement: http://www.mysql.com/doc/en/COMMIT.html Don't forget to SET AUTOCOMMIT=0; -- For technical support contracts, goto

Re[2]: Start Transaction in InnoDB

2002-10-30 Thread Dyego Souza do Carmo
Dobrý den, quarta-feira, 30 de outubro de 2002, 13:09:01, napsal jste: EE Alexander, EE Wednesday, October 30, 2002, 1:40:11 PM, you wrote: 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

Re: Re[2]: Start Transaction in InnoDB

2002-10-30 Thread Peter Brawley
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

RE: Re[2]: Start Transaction in InnoDB

2002-10-30 Thread Fernando Grijalba
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