how to get the num of rows of the sql result in python?

Question

I am quite familiar with the php but having troubles using sql in the python. In php, i used these lines to see if the query gives some result or not.

$query="SELECT ID FROM Employee WHERE user='$username' AND pass='$password'"; 

 $query_num_rows= mysql_num_rows($query_run); //returns number of rows

Is there such codes in the python? any resources would be appreciated too. i am having a hard time in using sql in python

BoshWash · Accepted Answer · 2014-03-13 20:53:04Z

2

The cursor has a rowcount property:

print(cursor.execute('SELECT ID FROM Employee').rowcount)

answered Mar 13, 2014 at 20:53

BoshWash

5,4804 gold badges34 silver badges50 bronze badges

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

2 Comments

Henry Keiter Over a year ago

So long as the cursor in question implements the DB API, anyway.

user3415869 Over a year ago

please check my answer below. i get some error :( @BoshWash

user3415869 · Accepted Answer · 2014-03-14 03:02:28Z

0

db= MySQLdb.connect("localhost","root","ahmed","practice")
    cursor=db.cursor()

    #checking phase to stop scrapping
    sql = "SELECT short_link FROM Properties WHERE Short_link='link_result'"
    print (cursor.execute(sql).rowcount)

i am using these lines and it gives error AttributeError: 'long' object has no attribute 'rowcount'

Then I used this which always give 0 result (shouldnt give zero since in the database, it should be matched)

sql = "SELECT Short_link FROM Properties WHERE Short_link='link_result'"
    print cursor.execute(sql)
    print cursor.rowcount

edited Mar 14, 2014 at 3:02

answered Mar 14, 2014 at 2:27

user3415869

912 silver badges10 bronze badges

2 Comments

BoshWash Over a year ago

does it still return 0 if you "SELECT * FROM Properties"?

BoshWash Over a year ago

also, if you have more questions don't post them as answers, just edit your original question or write a comment

Collectives™ on Stack Overflow

how to get the num of rows of the sql result in python?

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related