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,
原创
2020-12-05 14:12:25 ·
103 阅读 ·
0 评论