how do i extract integer values in fetching data from mysql database using python

Question

mycursor = mydb.cursor()

sql = "select electricityBalance from users" 
mycursor.execute(sql)
print (int(record[0]) for record in mycursor.fetchone())

but the output gives this <generator object at 0x0000000002CFF2A0>

try using cursor.fetchall()

nbk
– nbk

2021-07-05 10:32:34 +00:00
Commented Jul 5, 2021 at 10:32 — nbk
– nbk, Commented Jul 5, 2021 at 10:32

score 1 · Accepted Answer · 2021-07-05 11:09:17Z

1

According to this post, a generator expression is a "naked" for expression.

That is why you are getting <generator object at 0x0000000002CFF2A0>:

What you can do is this:

l1=[int(record[0]) for record in mycursor.fetchone()]
print(*l1)

Unpack a list.

You can also use .join method, but keep in mind that it requires elements which are strings.

print(','.join(str(int(record[0])) for record in mycursor.fetchone()))

edited Jul 5, 2021 at 11:09

answered Jul 5, 2021 at 10:31

user15801675

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

6 Comments

mostafa khalil Over a year ago

it gave me an error saying that "int" object is not subscriptable

user15801675 Over a year ago

Which part? First or second @mostafakhalil

mostafa khalil Over a year ago

first, the sencond one gave me syntac error unexpected EOF while parsing

user15801675 Over a year ago

@mostafakhalil, check it now?

mostafa khalil Over a year ago

the second one gave me the first's proplem " int is not subscriptable both same proplem

|

Collectives™ on Stack Overflow

how do i extract integer values in fetching data from mysql database using python

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related