refresh query with python
Hello everyone, have a question about python and Mariadb. I try to read in one table some info and it work correctly, my problem is when I try to do this with polling (1-10 seconds), data I can see is the same as in the begginning. example, I read one specific table where info are updated continusly but the data I can retrieve is alvays the same as the first reading and are not updated as are really in the table.how I can update reading? thank in advance
Answer Answered by Markus Mäkelä in this comment.
Make sure to either commit your transactions or enable autocommit: by default the connection has autocommit disabled. This page has some information on how you can enable autocommit.