how to 'live' withou transactions?

2001-02-12 Thread Christian Dechery

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




Re: how to 'live' withou transactions?

2001-02-12 Thread Rolf Hopkins

You could upgrade to the latest version which now supports transactions.

- Original Message -
From: "Christian Dechery" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 13, 2001 10:17
Subject: how to 'live' withou transactions?


 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


-
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