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 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.


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.