import pymysql

# 连接本地mysql执行sql语句
def ExecuteLocalMysqlSelect(sql):
    conn = pymysql.connect(host=‘127.0.0.1‘
                           ,user=‘root‘
                           ,password=‘root‘
                           ,port=3306
                           ,db=‘analyst‘
                           ,charset=‘utf8‘)
    cur = conn.cursor()
    a = cur.execute(sql)
    conn.close()
    #cur.description 获取列名
    return a,cur.description,cur.fetchall()