Re: group multiple queries.. if one fails all fail

2003-01-23 Thread Steve Edberg
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/

group multiple queries.. if one fails all fail

2003-01-23 Thread Ciprian I. Acatrinei
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

group multiple queries.. if one fails all fail

2003-01-23 Thread Ciprian I. Acatrinei
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