Python’s MySqlDB not getting updated row

by

This is an InnoDB table, right? InnoDB is transactional storage engine. Setting autocommit to true will probably fix this behavior for you.

conn.autocommit(True)

Alternatively, you could change the transaction isolation level. You can read more about this here:
http://dev.mysql.com/doc/refman/5.0/en/set-transaction.html

The reason for this behavior is that inside a single transaction the reads need to be consistent. All consistent reads within the same transaction read the snapshot established by the first read. Even if you script only reads the table this is considered a transaction too. This is the default behavior in InnoDB and you need to change that or run conn.commit() after each read.

This page explains this in more details: http://dev.mysql.com/doc/refman/5.0/en/innodb-consistent-read.html

More Related Contents:

  1. MySQL parameterized queries
  2. PyInstaller, spec file, ImportError: No module named ‘blah’
  3. How to insert pandas dataframe via mysqldb into database?
  4. Load CSV data into MySQL in Python
  5. Enable Python to Connect to MySQL via SSH Tunnelling
  6. UnicodeEncodeError: ‘latin-1’ codec can’t encode character
  7. How to replace Django’s primary key with a different integer that is unique for that table
  8. Writing to MySQL database with pandas using SQLAlchemy, to_sql
  9. MySQL “incorrect string value” error when save unicode string in Django
  10. How to use MySQLdb with Python and Django in OSX 10.6?
  11. Django : Table doesn’t exist
  12. Error loading MySQLdb Module ‘Did you install mysqlclient or MySQL-python?’
  13. Python MYSQL update statement
  14. Python Mysql, “commands out of sync; you can’t run this command now”
  15. How do I escape % from python mysql query
  16. MySQL: Get column name or alias from query
  17. Python Pandas write to sql with NaN values
  18. Why are some mysql connections selecting old data the mysql database after a delete + insert?
  19. ImportError: No module named MySQLdb
  20. Can’t install mysql-python (newer versions) in Windows
  21. Using Django database layer outside of Django?
  22. Python: use mysqldb to import a MySQL table as a dictionary?
  23. How to move a model between two Django apps (Django 1.7)
  24. InterfaceError (0, ”)
  25. What’s the difference between MySQLdb, mysqlclient and MySQL connector/Python?
  26. Remove duplicates in list of object with Python
  27. How do I get time from a datetime.timedelta object?
  28. django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb
  29. ‘pip install MySQL-python’ fails with ‘IndexError’
  30. How to insert / retrieve a file stored as a BLOB in a MySQL db using python

Leave a Comment