Python MySQLdb doesn't return all the data from the database

Question

I'm using the Python package MySQLdb to fetch data from a MySQL database. However, I notice that I can't fetch the entirety of the data.

import MySQLdb
db = MySQLdb.connect(host=host, user=user, passwd=password)

cur = db.cursor()

query = "SELECT count(*) FROM table"
cur.execute(query)

This returns a number less than what I get if I execute the exact same query in MySQL Workbench. I've noticed that the data it doesn't return is the data that was inserted into the database most recently. Where am I going wrong?

user2722968 · Accepted Answer · 2017-04-30 18:33:27Z

2

You are not committing the inserted rows on the other connection.

answered Apr 30, 2017 at 18:33

user2722968

17.4k5 gold badges58 silver badges77 bronze badges

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

8 Comments

Imran Over a year ago

How do I do that?

user2722968 Over a year ago

send a COMMIT

Imran Over a year ago

Sorry but what's the code and where should I put it?

user2722968 Over a year ago

When you insert the rows using workbench, your connection can see the rows it just inserted. Other connections can't, as long as the transaction is not committed. Send a COMMIT from Workbench after you inserted the rows and both COUNT(*) will match.

user2722968 Over a year ago

Then you are probably not on the same database :-)

|

Collectives™ on Stack Overflow

Python MySQLdb doesn't return all the data from the database

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related