Python2 + SQLite not returning all rows

Question

I'm trying to write a Python (2) script that manages a SQLite3 database. I'm having trouble getting all of the rows from the table and looping through them. My table has 218 rows (according to PHP and sqlite3.exe) yet Python only loops through 8.

import sqlite3 as sql

db = sql.connect('database.db')
c = db.cursor()
n = 0

for row in c.execute('select * from table'):
    n += 1

print n

What am I doing wrong? Is there some extra step that I need to take to get Python to loop through all of the rows?

Which eight records are looped through? (Print out some value in the loop.) — CL.
– CL., Commented Feb 19, 2014 at 8:18
The records seem to be randomly selected from the database - they aren't alphabetical or in the order SELECT * FROM table results in in sqlite3.exe — DoctorSelar
– DoctorSelar, Commented Feb 20, 2014 at 3:19

Marichyasana · Accepted Answer · 2014-02-18 23:51:07Z

1

I do something like this:

conn     = sqlite3.connect(filename)
cursor   = conn.cursor()
cursor.execute('SELECT * from tablename')
results  = cursor.fetchall()
print '\nindividual records'
for result in results:
    print result

answered Feb 18, 2014 at 23:51

Marichyasana

3,1621 gold badge21 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python2 + SQLite not returning all rows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related