Python, sum returned MySQL data

Question

'm fetching some data from MySQL database using:

cur.execute("SELECT memory FROM vm WHERE hv_id=5")
for row in cur.fetchall() :
print row[0]

This prints something like this:

I need sum the above and set it as a variable for further calculations.

alecxe · Accepted Answer · 2013-08-27 13:09:49Z

7

Why don't use SUM() in the query itself:

cur.execute("SELECT SUM(memory) FROM vm WHERE hv_id=5")
result = cur.fetchone()[0]

answered Aug 27, 2013 at 13:09

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

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

Comments

Hardy · Accepted Answer · 2013-08-27 13:22:35Z

0

another answer if you are finding something Pythonista

cur.execute("SELECT memory FROM vm WHERE hv_id=5")
result = sum(int(x) for x in cur.fetchall())
print result

or

result = sum(map(int, cur.fetchall()))

answered Aug 27, 2013 at 13:22

Hardy

1,5392 gold badges27 silver badges40 bronze badges