Repeated MySQL queries from Python return the same data [duplicate]

by

You need to commit the connection after each query. This commits the current transaction and ensures that the next (implicit) transaction will pick up changes made while the previous transaction was active.

# Main loop
while True:

    # SQL query
    sql = "SELECT * FROM table"

    # Read the database, store as a dictionary
    mycursor = mydb.cursor(dictionary=True)
    mycursor.execute(sql)

    # Store data in rows
    myresult = mycursor.fetchall()

    # Transfer data into list
    for row in myresult:
        myList[int(row["rowID"])] = (row["a"], row["b"], row["c"])

        print(myList[int(row["rowID"])])

    # Commit !
    mydb.commit()
    print("---")
    sleep (0.1)

The concept here is isolation levels. From the docs (emphasis mine):

REPEATABLE READ

This is the default isolation level for InnoDB. Consistent reads within the same transaction read the snapshot established by the first read.

More Related Contents:

  1. How can I connect to MySQL in Python 3 on Windows?
  2. Python 3.4.0 with MySQL database
  3. Python random.choice same output
  4. Python: read object from file in python
  5. How do I connect to a MySQL Database in Python?
  6. How to use a variable inside a regular expression?
  7. Purpose of calling function without brackets python
  8. How to deal with certificates using Selenium?
  9. Python sockets error TypeError: a bytes-like object is required, not ‘str’ with send function
  10. How to set Python’s default version to 3.x on OS X? [duplicate]
  11. Play an Animated GIF in python with tkinter
  12. PyQt4 Wait in thread for user input from GUI
  13. “list index out of range” when using sys.argv[1]
  14. Py2exe for Python 3.0
  15. Why can’t I use the method __cmp__ in Python 3 as for Python 2?
  16. Upload Image using POST form data in Python-requests
  17. Python Binomial Coefficient
  18. Install mysql-python (Windows)
  19. Installing MySQL Python on Mac OS X
  20. importing izip from itertools module gives NameError in Python 3.x
  21. rounding errors in Python floor division
  22. How can I see the formulas of an excel spreadsheet in pandas / python?
  23. Python 3 – Encode/Decode vs Bytes/Str [duplicate]
  24. Serialising an Enum member to JSON
  25. Python: Sorting items from top left to bottom right with OpenCV
  26. python 3 open() default encoding
  27. How can I simulate 2.x’s tuple unpacking for lambda parameters, using 3.x?
  28. Pygame make sprite walk in given rotation
  29. Calling Python script from C++ and using its output
  30. Python 3 sqlite parameterized SQL-query

Leave a Comment