Detailed explanation of the steps for python3 to use PyMysql to connect to mysql database

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

Currently MySQLdb does not support python3. .x, Python 3.

1.pymysql installation

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

pip install pymysql3

2.pymysql usage

If you want to use the mysqldb method, just add the following two lines of code at the beginning of the py file.

#引入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("查询失败")

The above is the detailed content of Detailed explanation of the steps for python3 to use PyMysql to connect to mysql database. For more information, please follow other related articles on the PHP Chinese website!