Understanding pdo mysql transactions

by

You are not going to find the answer in php documentation because this has nothing to do with php or pdo.

Innodb table engine in mysql offers 4 so-called isolation levels in line with the sql standard. The isolation levels in conjunction with blocking / non-blocking reads will determine the result of the above example. You need to understand the implications of the various isolation levels and choose the appropriate one for your needs.

To sum up: if you use serialisable isolation level with autocommit turned off, then the result will be 12000. In all other isolation levels and serialisable with autocommit enabled the result will be 11000. If you start using locking reads, then the result could be 12000 under all isolation levels.

More Related Contents:

  1. How do detect that transaction has already been started?
  2. PHP PDO and Mysql [closed]
  3. PDO Fetch statement only retrieves first column
  4. PHP – Using PDO with IN clause array
  5. How to properly set up a PDO connection
  6. PHP + MySQL transactions examples
  7. PHP PDO prepared statements
  8. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  9. How do I set ORDER BY params using prepared PDO statement?
  10. PDO binding values for MySQL IN statement [duplicate]
  11. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  12. PDO mysql: How to know if insert was successful
  13. mysql PDO how to bind LIKE
  14. implement LIKE query in PDO
  15. PHP PDO prepared statement — MySQL LIKE query
  16. Fetching single row, single column with PDO
  17. How to install pdo driver in php docker image?
  18. How do I loop through a MySQL query via PDO in PHP?
  19. MySQL retrieve variable from Stored Procedure in PHP PDO
  20. PDO error: SQLSTATE[HY000]: General error: 2031
  21. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  22. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  23. Use of PDO in classes [duplicate]
  24. How to handle PDO exceptions [duplicate]
  25. Check if row exists in the database before inserting
  26. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  27. PDO and MySQL Fulltext searches
  28. PHP/PDO/MySQL: inserting into MEDIUMBLOB stores bad data
  29. PHP prepared statements and transactions in a loop [duplicate]
  30. Using PDO Prepared Statement and Incrementing a column value

Leave a Comment