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

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

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

python3查詢數(shù)據(jù)庫信息

方法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("數(shù)量:"+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("數(shù)量:"+str(cout))

for row in cursor.fetchall():

print("編號："+str(row[0])+'? ? 名字：'+row[1]+"? ? 性別："+row[2])

connection.commit()

finally:

connection.close()