================================================================================
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()
