python中PyMySQL有什么用

pip install PyMySQL

# 为了兼容mysqldb，只需要加入

pymysql.install_as_MySQLdb()

import pymysql

conn = pymysql.connect(host='127.0.0.1', user='root', passwd="xxx", db='mysql')

cur = conn.cursor()

cur.execute("SELECT Host,User FROM user")

for r in cur:

    print(r)

cur.close()

conn.close()