By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,731 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,731 IT Pros & Developers. It's quick & easy.

Quering Mysql Databases

P: 1
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]))
Nov 27 '16 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 619
See Harry George's answer at https://bytes.com/topic/python/answe...46-typecasting
Nov 27 '16 #2

Post your reply

Sign in to post your reply or Sign up for a free account.