How to store count values in python

I want to compare two tables based on their total number of rows. So i use count(*) to count the total number of rows in both table.

My code is:

cur1.execute ("""SELECT COUNT(*) FROM 开发者_运维知识库mytable;""")

In order to store the total count return by this query,

I use

row = cur1.fetchone()

 result1 =  row[0] 

but it didn't help. Can anyone suggest me the solution?

---

cursor.fetchone() 

gives you the result directly..so no need to take its zeroeth element..what you want is given to you directly when you say:

row = cur1.fetchone()