python 读取sql

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