Python3.6连接mysql

================================================================================

python3.6还不支持MySQLdb和mysql-connector-python,所以使用pip安装pymysql

================================================================================

python3查询数据库信息

方法1：

#!/usr/bin/python

#coding=utf-8

import pymysql

import pymysql.cursors

connection=pymysql.connect(host='192.168.88.180',user='tay',password='Tay123..',db='aaa',port=3306,charset='utf8')

try:

with connection.cursor() as cursor:

sql='select*from student'

cout=cursor.execute(sql)

print("数量:"+str(cout))

for row in cursor.fetchall():

print("编号："+str(row[0])+'    名字：'+row[1]+"    性别："+row[2])

connection.commit()

finally:

connection.close()

=================================================================================

方法二：

#!/usr/bin/python

#coding=utf-8

import pymysql

connection=pymysql.connect(

host="192.168.88.180",

port=3306,

user="tay",

password="Tay123..",

db="aaa",

charset="utf8")

try:

with connection.cursor() as cursor:

sql='select*from student'

cout=cursor.execute(sql)

print("数量:"+str(cout))

for row in cursor.fetchall():

print("编号："+str(row[0])+'    名字：'+row[1]+"    性别："+row[2])

connection.commit()

finally:

connection.close()