How to write a mysql prepared SELECT statement in python 3 using LIMIT?

Question

idValue = 100
limitValue = 10000
query = "SELECT count(*) as count FROM oneTable WHERE id = (%s) LIMIT (%s)";
cursor.execute(query, (idValue, limitValue ))

This doesn't seem to be working. It fetches only 1 record corresponding to the id.

Baran Barakcin · Accepted Answer · 2017-09-29 13:50:37Z

1

I think that this should work as you want. If you print result, you can see result of your query.

idValue = 100
limitValue = 10000
query = "SELECT count(*) as count FROM oneTable WHERE id = {0} limit {1}".format(idValue,limitValue)
cursor.execute(query)
result = cursor.fetchall()

edited Sep 29, 2017 at 13:50

answered Sep 29, 2017 at 12:09

Baran Barakcin

411 silver badge7 bronze badges

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

2 Comments

gpk27 Over a year ago

it's not working. It does the same thing as above, fetches only 1 row. Any idea why?

Baran Barakcin Over a year ago

there should be one row that id = 1000, i think you should try to remove id filter.

gpk27 · Accepted Answer · 2017-10-10 09:39:53Z

1

The original query in the question does work. There was some other bug in my code and hence it ceased to work then. Thanks @Baran

answered Oct 10, 2017 at 9:39

gpk27

8292 gold badges9 silver badges19 bronze badges

Collectives™ on Stack Overflow

How to write a mysql prepared SELECT statement in python 3 using LIMIT?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related