How to read a single sequential record from MySQL?

VorlonInfoTech · 11-17-2004, 07:50 PM

I'm writing an application in MySQL and Python that must display several thousand records from a database. I wanted to use the MySQL "SELECT" command to select the records I want to see, and then use the "ORDER BY" directive to retrieve them in the correct order. But my python program will read in the entire select set into an array which may grow too large to process properly. Ideally, I want to retrieve a single record, display it, then retrieve the next record.

Can somebody suggest the MySQL command that will retrieve a single record in a sequence, and allow for then retrieving the next record?

crabboy · 11-17-2004, 11:08 PM

You need to setup a database cursor to fetch one row at a time.

I don't know python, but I'll take a stab at an example:

Code:

db = MySQLdb.connect(...)
cursor = db.cursor();
cursor.execute ( "Select first_name, last_name from user")
while (1):
  row = cursor.fetchone()
  if row == None:
    break
  print row[0] row[1]