2.python处理pymysql查询数据

# 原   因：python代码练习
# 编   写：zora
# 开发时间：2022/5/11 23:56
import pymysql
db_config={
    'user':'name',
    'password':'123456',
    'host':'www.bai.com',
    'database':'loan',
    'port':3306,
    'charset':'utf8',
    'cursorclass':pymysql.cursors.DictCursor
}
# 1.创建数据库连接
conn=pymysql.connect(**db_config)
# 2.创建游标
with conn.cursor() as cursor:
    sql='select * from member limit 10'
    cursor.execute(sql)
    # 获取一条数据
    res1=cursor.fetchone()
    print(res1)
    # 获取三条数据
    res2=cursor.fetchmany(3)
    # 获取剩下所有数据
    res3=cursor.fetchall()
conn.close()