Re: transactions
| From: | John Holmes | Date: | Mon, 29 Mar 2004 18:24:46 +0000 |
| Subject: | Re: transactions | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-181687@lists.php.net to get a copy of this message | ||
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 transactions? You just need to use Innodb table types and you can use transactions. ---John Holmes...