#pymysql

import pymysql
import seaborn as sns
# charset一定要写utf-8
connection = pymysql.connect(host="localhost",port=3306,user="root",password="123456")

def execute_sql(sql):
    cursor = connection.cursor()
    cursor.execute(sql)
    ##select使用
    res = cursor.fetchall()
    connection.commit()
    connection.close()