Monday, April 19, 2010

Count how many records (rows) you get from database in Python

import MySQLdb

conn = MySQLdb.connect(host,
                   user,
                   password,
                   dbName)

cursor = conn.cursor()

my_query="SELECT .."

cursor.execute (my_query)

# know how many rows you get
print cursor.rowcount

0 comments: