Store number of rows in mysql data in variable

Question

SELECT COUNT( *) as "Number of Rows"
FROM orders;

i want to add "Number of rows" into a python variable but idk how.

Answer 1

stored numbers of rows in python variables

db= MySQLdb.connect("HOSTNAME", "USER_NAME", "PWD", "DB_NAME");
cursor= db.cursor();
number_of_rows = cursor.execute("SELECT COUNT (*) FROM TBL");
print(number_of_rows);