# Querying Data - A Recommended Way
```
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,
    ),
)
~!@for (pk, name) in cursor:@!~
    print(f"PK of {name} is {pk}")
cursor.close()
conn.close()
```
----------------------------------------------
The example in the slide achieves the same results as the previous example, except it uses the cursor object itself to iterate through the result set row by row.