☰
python 读取sql
2026/10/17 6:27:34 网站建设 项目流程
def runsql(a): # 别用pandas来查, 他不会转义, 查出来不对. try: import pandas as pd pd.read_sql_query import pymysql conn = pymysql.connect(host='10.0.3.27', user="root", password='xxxxxxxxxxxxx', db="xxx", port=xxx) escaped = conn.escape_string(a) print(escaped) # 输出:O\'Neil(MySQL 用反斜杠转义单引号) cursor=conn.cursor() cursor.execute(a) conn.commit() create_sql = cursor.fetchall() cursor.close() conn.close() return create_sql except Exception as e: return e

需要专业的网站建设服务?

联系我们获取免费的网站建设咨询和方案报价,让我们帮助您实现业务目标

立即咨询