Python mysql select field based on variable

Question

I want to create a MySQL syntax to select a field based on a variable, what I have is:

book_category = "science"
mycursor_a.execute(("SELECT {book_categories} FROM research_papers WHERE book_Name = %s", (book,)).format(book_categories = book_category))

but I get the following error:

AttributeError: 'tuple' object has no attribute 'format'

Marzhal · Accepted Answer · 2022-11-11 05:59:26Z

1

That's because

(book,))

is a tuple and not an object, remember that tuples don't have dynamic reading like an object or dictionary.

To solve that we need a dictionary variable as a result.

can be achieved by setting the cursor.

mycursor_a= db.cursor( buffered=True , dictionary=True)
book_category = "science"
mycursor_a.execute(("SELECT {book_categories} FROM research_papers WHERE book_Name = %s", (book,)).format(book_categories = book_category))

answered Nov 11, 2022 at 5:59

Marzhal

1438 bronze badges

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

Comments

muhammad saad · Accepted Answer · 2022-11-11 06:08:49Z

1

Hi the reason it is not working becuase


("SELECT {book_categories} FROM research_papers WHERE book_Name = %s", (book,))

is considered as tuple (instead of string) and to avoid that you can use book same as you used book_categories

so here is my proposed solution to your value

book_category = "science"
book = "your value"
mycursor_a.execute("SELECT {book_categories} FROM research_papers WHERE book_Name = {variable}" ).format(book_categories = book_category ,  variable = book )

answered Nov 11, 2022 at 6:08

muhammad saad

947 bronze badges

Collectives™ on Stack Overflow

Python mysql select field based on variable

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related