命令行中执行:
easy_install pymysql3
然后新建python文件:
import pymysql
conn = pymysql.connect(host='127.0.0.1', user="root", passwd="123456", db="test")
cur = conn.cursor()
cur.execute("select * from users")
for r in cur:
print("row_number:", cur.rownumber, end=" :")
print("name:"+str(r[1])+" pass:"+str(r[2]) + " | "+r[1])
cur.close()
conn.close()
执行结果: