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 ")
data = cursor.fetchall()
db.close()
原文：https://www.cnblogs.com/infinite-BKB/p/14856821.html