Python3 players Pymysql to replace the MYSQLDB library.

Although you may be accustomed to mysqldb in python2.x, the component has not been supported in python3.x.

Instead, the following is:

Import Pymysql

So, everybody pip up. Although there is a news that MySQL official out of a new version, but I did not find.

Examples are as follows:

Import Pymysql

conn = Pymysql.connect (host= ' 127.0.0.1 ', port=3306, user= ' root ', passwd= ' test ',

db= ' MySQL ')

cur = conn.cursor ()

Cur.execute ("SELECT * from User")

For R in Cur.fetchall ():

Print (R)

#cur. Close ()

Conn.close ()

This article is from the "Orange with Ice it" blog, please be sure to keep this source http://verdureorange.blog.51cto.com/632758/1587703

Python3 players Pymysql to replace the MYSQLDB library.