-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Sun, Mar 11, 2001 at 09:40:28PM -0600, Mike<mickalo>Blezien wrote:
> This maybe more of a MySQL question than DBI, but I have a Perl script that does
> 4 INSERTS into various tables. I know MySQL doesn't support Transactions, but
> when the data is inserted into the tables and during the process a error is
> encountered during an insert, is there an way to undo what was entered into any
> other tables prior to the error. I normally use "$dbh->do($query); on all
> UPDATES and INSERTS.
>
> any suggestion much appreciated.
Suggestions: Postgre, Oracle, several others. MySQL is just now starting to
figure out the need for transactions, and their current implementation
definitely qualifies as a hack. If ACID is this important to you I would
migrate to a more robust platform. You'll thank yourself later.
The only other solution is to implement your own initial state logging and
transaction system in your program, which is definitely more trouble than just
finding a database that does things properly out of the box.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8
iQA/AwUBOqxe7wOGqGs0PadnEQLoqQCg+WIeH8ZzZx32QnW3ljUHBXsr56oAn1Ee
smfnWs2BI3abl/vAJi265NRQ
=2kaV
-----END PGP SIGNATURE-----
