My sql select query during long updates on the same table. Junk or old data?
It is controlled by Transaction Isolation Levels in MySQL. Default Transaction Islation Level is Repeatable Read. With this you will see the old data until it is committed.