Python 3.6 连接 MySQL DB

连接MySQL DB,需引入pymysql (由于Python3 不支持 MySQL-Python ),

pip install pymysql

import pymysql
import  pymysql.cursors
connection = pymysql.connect(host='localhost',  
                             user='root',  
                             password='root',  
                             db='test',  
                             port=3306,  
                             charset='utf8')#注意是utf8不是utf-8
try:  
    with connection.cursor() as cursor:  
        sql = 'select * from users'  
        cout_1=cursor.execute(sql)  
        print("数量： "+str(cout_1))  
        for row in cursor.fetchall():  
            print("id:",str(row[0]),'name',str(row[1]),'age',str(row[2]))  

finally:  
    connection.close()