当前位置: 首页 > news >正文

python 读取sql

python 读取sql

def runsql(a): # 别用pandas来查, 他不会转义, 查出来不对.try:import pandas as pdpd.read_sql_queryimport pymysqlconn = 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_sqlexcept Exception as e:return e