how to extract a value from database using python

Question

I want to get a value from a database table using python. I am sending a query and getting value like this:

conn = pymysql.connect(rds_host, user=name, passwd=password,db=db_name, connect_timeout=10)
with conn.cursor() as cur:
    cur.execute("SELECT id FROM user_details WHERE email='{}'".format(email)
    for row in cur:
        id = row[0]

Is there a way to get the value without using for loop.

How many values do you expect to get? If just one, you can use id_=next(cur)[0]. As a side note, do not call your variables id. — DYZ
– DYZ, Commented Feb 19, 2018 at 8:19

bruno desthuilliers · Accepted Answer · 2018-02-19 08:18:24Z

2

Couldn't find the doc ?

https://pymysql.readthedocs.io/en/latest/modules/cursors.html#pymysql.cursors.Cursor.fetchone

cursor.fetchone()

Fetch the next row

Also, you definitly DONT want to use string formatting to build your queries (unless you're ok to have your app wide opened to sql injections of couse). You want to use prepared queries instead:

cur.execute("SELECT id FROM user_details WHERE email=?", [email,])

answered Feb 19, 2018 at 8:18

bruno desthuilliers

78.3k6 gold badges102 silver badges129 bronze badges

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

1 Comment

Preethi Over a year ago

To get a single value, it should be a = cursor.fetchone(); new_id = a[0];

Collectives™ on Stack Overflow

how to extract a value from database using python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related