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
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268]
updated 1268 (MySQL User Forums), inserted 30, updated 0, at 2012-06-02 00:11:15
