Hello.
In my opinion, you should use SERIALIZABLE transaction isolation level or
SELECT ... LOCK IN SHARE MODE.
"?ngelo M. Rigo" <angelomrigo@stripped> wrote:
> [-- text/plain, encoding 8bit, charset: iso-8859-1, 25 lines --]
>
> Hi
>
> I am using innodb tables to implement transactions on my system
>
> here is the pseudo code:
> SET AUTOCOMMIT = 0
> BEGIN
> if(erro){
> ROLLBACK
> } else {
>
> COMMIT
> }
>
> When i do commit a transaction and list the data im my web aplication the records are
> not acurate .
>
> How can i get the rigth data ?
>
> I search on documentation and find somthing like read comited how can make a select
> using read commited if ths clause is not on the select sintax?
>
> Tnak?s in advance
>
>
> ---------------------------------
> Yahoo! Acesso Gr?tis - Internet r?pida e gr?tis. Instale o discador do Yahoo!
> agora.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
