I believe you can use transactions with InnoDB tables on MySQL, if this
is the case, a simple BEGIN; to begin your transaction, and a
COMMIT; to save all the changes, plus a ROLLBACK; to undo your
changes, should be sufficient.
On Mon, 2004-03-29 at 13:12, Matthew Oatham wrote:
Hi,
Is there
Matthew Oatham wrote:
Hi,
Is there an elegant way to recover from DB errors in MySQL using PHP,
i.e. transactions and rolling back - basically I have an insert
statement then an update statement. if the insert succeeds the update
is run but if the update fails I want to undo the insert!
Matthew Oatham wrote:
Is there an elegant way to recover from DB errors in
MySQL using PHP, i.e. transactions and rolling back -
basically I have an insert statement then an update
statement. if the insert succeeds the update is run
but if the update fails I want to undo the insert!
Use
Though I know there are many people out there who cringe at the thought
of using DB abstraction layers, I really like ADOdb and it has very nice
transaction support built in (as long as the underlying database
supports it, obviously).
I don't know why people hate them sothey make life so
yup - use transactions.
http://www.mysql.com/doc/en/COMMIT.html
--- Matthew Oatham [EMAIL PROTECTED] wrote:
Hi,
Is there an elegant way to recover from DB errors in
MySQL using PHP, i.e. transactions and rolling back
- basically I have an insert statement then an
update statement. if the
Is there anyway to do something similar to Transactions in mysql?
Yes, use transactions
http://www.mysql.com/doc/en/Transactional_Commands.html
-Craig
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Is there anyway to do something similar to Transactions in mysql?
Yes -- http://www.mysql.com/doc/en/ANSI_diff_Transactions.html
--
Lowell Allen
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Diana Castillo wrote:
Is there anyway to do something similar to Transactions in mysql?
Maybe the transaction section of the MySQL manual will help you out?
http://www.mysql.com/doc/en/Transactional_Commands.html
--
By-Tor.com
It's all about the Rush
http://www.by-tor.com
--
PHP General
look at the syntax for locking the tables.
Curtis
- Original Message -
From: "Christian Dechery" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, February 11, 2001 7:14 PM
Subject: [PHP] transactions
Hi,
I was reading mysql's manual, about transactions and all... and I didn't
9 matches
Mail list logo