pumysql查询操作

import pymysql
from pymysql.cursors import DictCursor  # 查询返回的是字典，列表
conn = pymysql.connect(
    user="root",
    password="1234",
    host="localhost",
    database="spider",  # 链接mysql里面的哪一个,要修改
    port=3306,
)
cursor = conn.cursor(DictCursor)
sql = "select * from stu"
ret = cursor.execute(sql)
# print(ret)  # 拿到表里面数据的个数
# 注意，查询操作，返回的操作在cursor里
# one = cursor.fetchone()  # fetchone() 一次拿出一条数据
# print(one)
all = cursor.fetchall()  # 全拿
print(all)
# many = cursor.fetchmany(2)  # 指定拿多少条数据
# print(many)
cursor.close()
conn.close()