May be this is a newbie question but want to confirm as this is important for my app:
I'm using MySQLdb on Python and my code looks like:
db = MySQLdb.connect("localhost","root","",test) cursor = db.cursor() cursor.execute("UPDATE users SET address = 'Something' WHERE name = 'Someone'") db.query("SELECT * FROM users WHERE address = 'Something'") sample=db.store_result().fetch_row(maxrows=0)
So the question is, will sample contain the row that was changed by the uncommitted update?
In the real app, I am making some complex queries with subclauses like GROUP_CONCAT, etc. Will all these work with uncommitted updates? (In the sense that can these work on the rows updated by uncommitted updates)