how print count table sql in python

Question

im trying to print count table in python, im write this code:

count = cur.execute("SELECT COUNT(*) FROM %s;" str(table))
print count

all print results is 1, (think 1 = true), how i can print the real result of my sql command ?

thanks

Marcos · Accepted Answer · 2014-02-02 12:39:34Z

3

You must fetch the result:

cursor = db.cursor()
count = cursor.execute("SELECT COUNT(*) FROM " + str(table))
db.commit()
print cursor.fetchone()[0]
cursor.close()

answered Feb 2, 2014 at 12:34

Marcos

4,6637 gold badges35 silver badges62 bronze badges

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

2 Comments

count = (1332L,) what is 1332L ? i need number result !

fetchone returns a tuple. I've added [0] so you can print just the number.