Python3 using Pymysql to connect to MySQL database

One: Pymysql package installation (Window System under Python3)

Easy_install Pymysql

Two: MySQL and python interactive use

1 ImportPymysql2 Try:3     #get a database connection4conn = Pymysql.connect (host='localhost', user='Root', port=3306,passwd='Root', db='QE', charset='UTF8')5     #create an object to execute the SQL statement6Cur =conn.cursor ()7Cur.execute ('SELECT * FROM Students')8     #data = Cur.fetchone () #执行sql语句时获取第一行数据9data = Cur.fetchall ()#when you execute an SQL statement, you get all the rows, one row constitutes a tuple, and the elements are assembled into a tuple to returnTen      forDinchData: One         Print(d) ACur.close ()#g Close Object -Conn.close ()#Close Connection - exceptException:Print('Query failed')

To work hard, insist!! 2018-03-28

Python3 using Pymysql to connect to MySQL database