Accessing one value from MySQL using pymysql in python

Question

I am trying to fetch one value from a database using pymysql. My current solution is 3 lines of code. Is this the best way to handle this?

import pymysql

conn = pymysql.connect(host='localhost', user='root', passwd='')
conn.autocommit(True)
cur = conn.cursor()

memory = '100'

# I want to access one item from mySQL
cur.execute("""SELECT id FROM scada.sensors WHERE memory='{}'""".format(memory))
for x in cur.fetchall(): # only runs once
   sensor_id=x[0]

Do I need this for loop to access the contents of cur.fetchall()?

I am using Python 3.2.3

Jeff Tratner · Accepted Answer · 2012-08-23 22:39:54Z

5

If you are only interested in one value (or the first value), you can just use the fetchone method in place of fetchall. Here's an example from the docs for MySQLdb (pymysql says it copies the entire MySQLdb API).

answered Aug 23, 2012 at 22:39

Jeff Tratner

17.3k4 gold badges50 silver badges68 bronze badges

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

Collectives™ on Stack Overflow

Accessing one value from MySQL using pymysql in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related