I was over-thinking it. And this is an InnoDB table, so I'm not sure why it autocommitted.
Just put in your simpler version and yup, it works.
Doh!
I was over-thinking it. And this is an InnoDB table, so I'm not sure why it autocommitted.
Just put in your simpler version and yup, it works. --
Drew |
How to do atomic select without limit in subquery?
- (drook)
- (2)
- Feb. 3, 2010, 01:14:40 PM EST
Several things happening there.
- (static)
- (1)
- Feb. 3, 2010, 06:48:11 PM EST
Doh!
- (drook)
- Feb. 3, 2010, 08:27:14 PM EST