import mysql.connector

conn = mysql.connector.connect(
    database="test",
    host="127.0.0.1",
    port=4000,
    user="root",
    password="",
)
cursor = conn.cursor()
query = """
  SELECT pk, name FROM t1 WHERE pk between %s and %s
  """
start_idx = 1
end_idx = 10
cursor.execute(
    query,
    (
        start_idx,
        end_idx,
    ),
)
row = cursor.fetchone()
while row is not None:
    print(row[0], row[1])
    row = cursor.fetchone()
cursor.close()
conn.close()