python3 uses PyMysql to connect to mysql database

Python language 3.x is completely incompatible with the future. As a result, libraries that we can use normally in python2.x cannot be used in python3. For example, mysqldb

Currently, MySQLdb does not support python3.x and Python3.x. Solutions for connecting to MySQL include: oursql, PyMySQL, myconnpy, etc.

Let’s talk about how to install and use pymysql in python3. I will talk about the other two solutions later.

1.pymysql installation

pymysql is a replacement for mysqldb in python3 environment. Enter the command line and use pip to install pymysql

pip install pymysql3

2.pymysql use

If you want to use mysqldb, then directly at the beginning of the py file Just add the following two lines of code.

#引入pymysql
import pymysql 
#当成是mysqldb一样使用，当然也可以不写这句，那就按照pymysql的方式
pymysql.install_as_MySQLdb()

3. pymysql query example

__author__ = 'pythontab.com'
#导入pymysql的包
import pymysql
try:
    #获取一个数据库连接，注意如果是UTF-8类型的，需要制定数据库
    conn=pymysql.connect(host='localhost',user='pythontab',passwd='pythontab',db='pythontab',port=3306,charset='utf8')
    cur=conn.cursor()#获取一个游标
    cur.execute('select * from user')
    data=cur.fetchall()
    for d in data :
        #注意int类型需要使用str函数转义
        print("ID: "+str(d[0])+'  用户名： '+d[1]+"  注册时间： "+d[2])
    cur.close()#关闭游标
    conn.close()#释放数据库资源
except  Exception :print("查询失败")