python 读取sql

📅 发布时间:2026/7/13 1:59:06 👁️ 浏览次数:
python 读取sql
def runsql(a): # 别用pandas来查, 他不会转义, 查出来不对. try: import pandas as pd pd.read_sql_query import pymysql conn pymysql.connect(host10.0.3.27, userroot, passwordxxxxxxxxxxxxx, dbxxx, portxxx) escaped conn.escape_string(a) print(escaped) # 输出O\Neil(MySQL 用反斜杠转义单引号) cursorconn.cursor() cursor.execute(a) conn.commit() create_sql cursor.fetchall() cursor.close() conn.close() return create_sql except Exception as e: return e