Python when reading a mysql data in mysql has new data, but through the following SQL always can't get the latest data, or to get the data rows of 0
Innodb
SELECT id, data FROM tableA WHERE id & gt; The ORDER 10000 BY id ASC LIMIT 1000

The solution is:
Python USES the mysqldb in access mysql connection. Need to add mysqlconn autocommit (=true)


The question is:
Why select also want the autocommit mode?