note 104797 added to mysqli.rollback
| From: | mfaust at usinternet dot com | Date: | Thu, 07 Jul 2011 15:47:45 +0000 |
| Subject: | note 104797 added to mysqli.rollback | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-181332@lists.php.net to get a copy of this message | ||
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.
----
Server IP: 69.147.83.197
Probable Submitter: 216.17.68.195
----
Manual Page -- http://www.php.net/manual/en/mysqli.rollback.php
Edit -- https://master.php.net/note/edit/104797
Del: integrated -- https://master.php.net/note/delete/104797/integrated
Del: useless -- https://master.php.net/note/delete/104797/useless
Del: bad code -- https://master.php.net/note/delete/104797/bad+code
Del: spam -- https://master.php.net/note/delete/104797/spam
Del: non-english -- https://master.php.net/note/delete/104797/non-english
Del: in docs -- https://master.php.net/note/delete/104797/in+docs
Del: other reasons-- https://master.php.net/note/delete/104797
Reject -- https://master.php.net/note/reject/104797
Search -- https://master.php.net/manage/user-notes.php