Select single item in MYSQLdb - Python

Question

I've been learning Python recently and have learned how to connect to the database and retrieve data from a database using MYSQLdb. However, all the examples show how to get multiple rows of data. I want to know how to retrieve only one row of data.

This is my current method.

cur.execute("SELECT number, name FROM myTable WHERE id='" + id + "'")
results = cur.fetchall()
number = 0
name = ""
for result in results:
    number = result['number']
    name = result['name']

It seems redundant to do for result in results: since I know there is only going to be one result.

How can I just get one row of data without using the for loop?

alecxe · Accepted Answer · 2016-09-15 19:10:31Z

17

.fetchone() to the rescue:

result = cur.fetchone()

answered Sep 15, 2016 at 19:10

alecxe

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

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

Comments

levi · Accepted Answer · 2016-09-15 19:24:24Z

1

use .pop()

if results:
   result = results.pop() 
   number = result['number']
   name = result['name']

edited Sep 15, 2016 at 19:24

answered Sep 15, 2016 at 19:10

levi

22.8k7 gold badges79 silver badges76 bronze badges

2 Comments

Gary Holiday Over a year ago

What if the cur.execute() didn't return any results? How would results.pop() behave?

levi Over a year ago

@GaryJohnson put them inside a if to check if results if empty or not.

Collectives™ on Stack Overflow

Select single item in MYSQLdb - Python

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related