note 104797 deleted from mysqli.rollback by danbrown
| From: | danbrown@php.net | Date: | Thu, 07 Jul 2011 15:56:12 +0000 |
| Subject: | note 104797 deleted from mysqli.rollback by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-181333@lists.php.net to get a copy of this message | ||
Note Submitter: mfaust at usinternet dot com
----
In regards to the note posted by jd at dilltree dot com:
The reason your DELETE statement doesn't work after a rollback is that you are either
forgetting to COMMIT the delete or haven't turned autocommit back on. If you fail to do either
of those and the script terminates then an auto-rollback gets performed and your DELETE never
happens, thus the deleted rows reappear.