How can I do 'transaction' withou begin/commit/rollback?

I don't understando how lock tables can replace it...

if I have

update thing set this=this;
insert into stuff values(this, this and that);
insert into thing_stuff values(from both thing and stuff);

or whatever... and I want to be sure the ALL of them are carried out or NONE...
if I had transactions I could do checks for each query and if something 
went wrong just rollback... but without it, I can even start to imagine...

please, enlighten me... :)
____________________________
. Christian Dechery (lemming)
. http://www.tanamesa.com.br
. Gaita-L Owner / Web Developer


---------------------------------------------------------------------
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

Reply via email to