note 98309 added to pdo.begintransaction

be aware that you also can not use TRUNCATE TABLE as this statement will trigger a commit just like CREATE TABLE or DROP TABLE it is best to only use SELECT, UPDATE and DELETE within a transaction, all other statements may cause commits thus breaking the atomicity of your transactions and their ability to rollback obviously you can use DELETE FROM <table> instead of TRUNCATE TABLE but be aware that there are differences between both statements, for example TRUNCATE resets the auto_increment value while DELETE does not. ---- Server IP: 69.147.83.197 Probable Submitter: 85.178.224.104 ---- Manual Page -- http://www.php.net/manual/en/pdo.begintransaction.php Edit -- https://master.php.net/note/edit/98309 Del: integrated -- https://master.php.net/note/delete/98309/integrated Del: useless -- https://master.php.net/note/delete/98309/useless Del: bad code -- https://master.php.net/note/delete/98309/bad+code Del: spam -- https://master.php.net/note/delete/98309/spam Del: non-english -- https://master.php.net/note/delete/98309/non-english Del: in docs -- https://master.php.net/note/delete/98309/in+docs Del: other reasons-- https://master.php.net/note/delete/98309 Reject -- https://master.php.net/note/reject/98309 Search -- https://master.php.net/manage/user-notes.php