Python3 using Pymysql to connect to MySQL database

The Python language's 3 x is completely non-forward compatible, resulting in a library that we can work with in Python2 X, which is python3 for example MYSQLDB currently MYSQLDB does not support Python3

The 3.x of the Python language is completely non-forward compatible, resulting in a library that we can use normally in python2.x, which is not available to Python3. For example MySQLdb

Currently MYSQLDB does not support python3.x, python3.x connection to MySQL program is: Oursql, Pymysql, MYCONNPY, etc.

Below is the next Python3 how to install and use Pymysql, another two options I will talk about later.

1.pymysql Installation

Pymysql is a substitute for mysqldb in the PYTHON3 environment, enter the command line and use PIP to install Pymysql

1	pip installpymysql3

2.pymysql use

If you want to use MYSQLDB, then directly at the beginning of the Py file add the following two lines of code.

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

3. Pymysql Query Example

123456789101112131415

__author__ =‘pythontab.com‘#导入pymysql的包importpymysqltry:    #获取一个数据库连接，注意如果是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()    ford indata :        #注意int类型需要使用str函数转义        print("ID: "+str(d[0])+‘  用户名： ‘+d[1]+"  注册时间： "+d[2])    cur.close()#关闭游标    conn.close()#释放数据库资源exceptException :print("查询失败")

Python3 using Pymysql to connect to MySQL database