This would be called transactions: your're looking for COMMIT/ROLLBACK. As far as I know, transactions are only available on BDB and InnoDb table types. See

http://www.mysql.com/doc/en/Transactional_Commands.html

http://www.mysql.com/doc/en/InnoDB_overview.html



At 12:24 AM 1/23/03 , Ciprian I. Acatrinei wrote:
Hi,

I looked a lot and I couldn't find a solution to this problem:

Ex: I have 5 queries. I run them and one of them fails. The rest are ok.
So 4 tables are affected and one is not. Is there a way of testing the
queries if they will be successful and only if all of them are then they
should be run?

Thank you,
--
Ciprian I. Acatrinei <[EMAIL PROTECTED]>


---------------------------------------------------------------------
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
+------------------------------------------------------------------------+
| Steve Edberg                                      [EMAIL PROTECTED] |
| Database/Programming/SysAdmin                            (530)754-9127 |
| University of California, Davis             http://pgfsun.ucdavis.edu/ |
+---------------------- Gort, Klaatu barada nikto! ----------------------+


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