如何使用 mysql.connector 禁用查询缓存
我正在我的 Kivy 应用程序上连接 mysql.
I'm connecting mysql on my Kivy application.
import mysql.connector
con = mysql.connector.Connect(host='XXX', port=XXX, user='XXX', password='XXX', database='XXX')
cur = con.cursor()
db = cur.execute("""select SELECT SQL_NO_CACHE * from abc""")
data = cur.fetchall()
print (data)
从另一个连接对表 abc 插入或删除后；我在 python 上调用相同的查询；但数据没有更新.
After inserting or deleting on table abc from another connection; i call the same query on python; but data is not updating.
我添加了查询SET SESSION query_cache_type = OFF;"在选择查询之前，但它没有工作.有人说select NOW() ..."查询不可缓存，但它不再起作用.我该怎么办?
I add the query "SET SESSION query_cache_type = OFF;" before select query, but it didn't work. Someone said "select NOW() ..." query is not cachable but it didn't work again. What should I do?
推荐答案
我通过在 fetchall() 之后添加代码解决了这个问题
I solved this by adding the code after fetchall()
con.commit()
在不执行提交的情况下调用相同的选择查询，不会更新结果.
Calling the same select query without doing a commit, won't update the results.
相关文章