selecting next row given a composite key (no replies)
(MySQL.com) Folks,
I have a database with a billion rows in each of several tables that have composite keys. Given a particular row, I need to get the next few rows. If I had a simple key called, say, (id), I could do this:
SELECT * FROM mytable WHERE i