python连接mysql数据库
import pymysql
conn = pymysql.connect(
host=“localhost”,
user=“root”,password=“xxxxxx”,
database=“xxxxxx”,
charset=“utf8”) #连接数据库
cursor = conn.cursor()
cursor.execute(“select * from xxxxxx”) #查询数据库表
results = cursor.fetchall() #对查询结果进行进行遍历展示
for rows in results: #遍历行
for row in rows: #遍历行里的字段
print("~~",row)
cursor.close()
conn.close()