note 101187 added to pdo.transactions
| From: | Roger at osu1 dot php dot net | Date: | Wed, 01 Dec 2010 14:52:05 +0000 |
| Subject: | note 101187 added to pdo.transactions | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-174522@lists.php.net to get a copy of this message | ||
Hey Josh,
A "drop table" is not something that will encapsulated within a transaction. A drop table
statement is a DDL not a DML. Because a drop table statement alters the state of the database, not
simply the data. DMLs are SELECTS, INSERTS, DELETES, and UPDATES. These statements do nothing for
your database structure, but simply changes and "manipulates" your data within ur
structure (tables).
DDLs are final, has no commits, no rollbacks. :D
Roger
----
Server IP: 69.147.83.197
Probable Submitter: 149.10.161.172
----
Manual Page -- http://www.php.net/manual/en/pdo.transactions.php
Edit -- https://master.php.net/note/edit/101187
Del: integrated -- https://master.php.net/note/delete/101187/integrated
Del: useless -- https://master.php.net/note/delete/101187/useless
Del: bad code -- https://master.php.net/note/delete/101187/bad+code
Del: spam -- https://master.php.net/note/delete/101187/spam
Del: non-english -- https://master.php.net/note/delete/101187/non-english
Del: in docs -- https://master.php.net/note/delete/101187/in+docs
Del: other reasons-- https://master.php.net/note/delete/101187
Reject -- https://master.php.net/note/reject/101187
Search -- https://master.php.net/manage/user-notes.php