Fun MySQL fact of the day: how many rows?

While trying to make sense the best I could of the code paths responsible for implementing SELECT ... LIMIT, I stumbled across a relic of MySQL. I'll admit, it seemed so strange at the time that I wasted too much time trying to understand what and why it existed before ... read more

Fun MySQL fact of the day: OFFSET

On Friday, we discussed a simple fact about LIMIT, and that wasn't just because it was Friday (well, maybe a bit), but because I felt it important to have a refresher on how MySQL and the storage engine interact before we look at OFFSET. ... read more

Fun MySQL fact of the day: LIMIT your expectations

Before we take a close look at OFFSETs next week, we're going to take a quick peek inside MySQL to understand how a simple SELECT ... LIMIT works, and while we're going to consider a simple case, we're also going to fold in some information we've ... read more
1 2 3 4 5 6 7