Skip to content

Instantly share code, notes, and snippets.

@bmcculley

bmcculley/startrow.py

Created April 18, 2015 14:04
Show Gist options
  • Save bmcculley/44c04bafc42fbd39cc18 to your computer and use it in GitHub Desktop.
Save bmcculley/44c04bafc42fbd39cc18 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
startrow.py
start_row = 0
while True:
cursor = conn.cursor()
cursor.execute("SELECT item FROM items LIMIT %d,1000" % start_row)
rows = cursor.fetchall()
if not rows:
break
start_row += 1000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment