查询数据:
import pymysql
config = {
'host':'localhost',
'port':3306,
'user':'root',
'passwd':'root',
'db':'logon',
'charset':'utf8'
}
# 打开数据库连接
conn = pymysql.connect(**config)
try:
# 使用 cursor() 方法创建一个游标对象 cursor
cursor = conn.cursor()
# SQL 查询语句
sql = "SELECT * FROM logon_people \
WHERE age"
# 执行SQL语句
cursor.execute(sql)
# 获取所有记录列表
results = cursor.fetchall()
print(results)
for row in results:
name = row[1]
age = row[2]
phone = row[5]
# 打印结果
print("name=%s,age=%s,phone=%s," %(name,age,phone))
# 关闭游标
cursor.close()
# 关闭链接
conn.close()
print("查询成功")
except:
print("查询失败")
# 发生错误时回滚