【Python】pymysql使用模板

import pymysql 

db = pymysql.connect(host="localhost", port=3306, user="root", passwd="xxx", db="stu_info")
cursor = db.cursor(cursor=pymysql.cursors.DictCursor)
cursor.execute("SELECT account,psw FROM account Where xxx")
data = cursor.fetchall()
db.close()

 

posted @ 2021-06-06 23:10  纯正·老王  阅读(85)  评论(0)    收藏  举报