如何从db中获取所有表名并对它们进行分页

import mysql.connector

def get_table_names(db_config, page_size=10, page_number=1):
    # 连接到数据库
    conn = mysql.connector.connect(**db_config)
    cursor = conn.cursor()
    
    # 计算偏移量
    offset = (page_number - 1) * page_size
    
    # 查询表名
    query = """
    SELECT table_name 
    FROM information_schema.tables 
    WHERE table_schema = %s 
    LIMIT %s OFFSET %s
    """
    cursor.execute(query, (db_config['database'], page_size, offset))
    
    # 获取结果
    table_names = [row[0] for row in cursor.fetchall()]
    
    # 关闭连接
    cursor.close()
    conn.close()
    
    return table_names

# 数据库配置
db_config = {
    'host': 'localhost',
    'user': 'your_user',
    'password': 'your_password',
    'database': 'your_database'
}

# 获取第一页的表名，每页显示10个
table_names = get_table_names(db_config, page_size=10, page_number=1)
print(table_names)