Quering Mysql Databases

[Kumar01]

Hi am new to python,
am trying fetch data from mysql DB and need to manipulated it.
the data type of Output query is tuple but i need it in int to perform arithmetic operation. kindly suggest.

cursor = cnx.cursor()
cursor.execute( "SELECT mobileno FROM mobile")
rows = cursor.fetchall ()
print('Total Row(s):', cursor.rowcount )
for row in rows:
print(type(row[0]))

[dwblas]

See Harry George's answer at https://bytes.com/topic/python/answe...46-typecasting