本文介绍了SQLAlchemy:如何使用SQLAlchemy更改MySQL服务器系统变量?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想使用SQLAlchemy设置general_log和general_log_file变量,有没有办法做到这一点?我一直在Google搜索,找不到关于该主题的任何内容.
I want to set the general_log and general_log_file variables using SQLAlchemy, is there a way to do this? I've been Googling around and can't find anything on the topic.
推荐答案您可以执行所需的任何原始SQL查询(当然,您必须在会话中获得适当的权限).要更改变量,请运行以下命令:
You can execute any raw SQL query which you need (of course you have to get appropriate rights in the session). To change a variable run something like this:
# change variable name and values to what you need connection.execute("SET SESSION query_cache_type = OFF")更多推荐
SQLAlchemy:如何使用SQLAlchemy更改MySQL服务器系统变量?
发布评论