python3连接mysql(pycharm)

import pymysql
conn = pymysql.connect(host="localhost", user="root", password="1234", database="hisdb", charset="utf8")
cursor = conn.cursor()
#sql = "DELETE FROM trade WHERE id=%s;"
sql = "INSERT INTO trade(name, id) VALUES (%s, %s);"

cursor.execute(sql, ['wsww', 1])
conn.commit()

cursor.close()
conn.close()

//注安装pyMysql库，file->setting...库安装慢解决方法是改下库下载地址