如何使用 Python 在 MySQL 数据库中进行数据切片和切块操作

import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='root', password='123456', db='test', charset='utf8', cursorclass=pymysql.cursors.DictCursor)

# 获取数据库游标
cursor = conn.cursor()

# 查询数据总数
sql = "SELECT COUNT(*) AS cnt FROM user"
cursor.execute(sql)
result = cursor.fetchone()
total_count = result['cnt']

# 设置分页参数
page_size = 10  # 每页数据条数
total_page = total_count // page_size + (1 if total_count % page_size > 0 else 0)  # 总页数

# 获取第一页数据
sql = "SELECT * FROM user LIMIT %s OFFSET %s"
cursor.execute(sql, (page_size, 0))
result = cursor.fetchall()
print(result)

# 获取第二页数据
cursor.execute(sql, (page_size, 10))
result = cursor.fetchall()
print(result)

# 关闭游标和连接
cursor.close()
conn.close()