#  `Connector/Python` - 查询数据 - 示例
```
from mysql.connector import connect;
conn = connect(database='test', host='127.0.0.1', port=4000, user='root', password='so_hard_to_guess'
)
cursor = conn.cursor()
query = (
  '''
  SELECT id, name FROM t1 WHERE id 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()
```
--------------------------------------------------------------