mysql 分页获取总页数

SELECT COUNT(*) AS total_count FROM table_name;

total_pages = (total_count + limit - 1) // limit

import mysql.connector

# 连接数据库
db = mysql.connector.connect(
    host="localhost",
    user="your_username",
    password="your_password",
    database="your_database"
)

cursor = db.cursor()

# 查询总记录数
cursor.execute("SELECT COUNT(*) AS total_count FROM table_name")
result = cursor.fetchone()
total_count = result[0]

# 每页显示的记录数
limit = 10

# 计算总页数
total_pages = (total_count + limit - 1) // limit

# 分页查询示例（第一页）
offset = 0
cursor.execute(f"SELECT * FROM table_name LIMIT {offset}, {limit}")
data = cursor.fetchall()

# 打印结果
print(f"总页数: {total_pages}")
print("第一页数据:")
for row in data:
    print(row)

# 关闭连接
cursor.close()
db.close()