MySQL Forums
Forum List  »  Quality Assurance

Advanced Search
New Topic

Re: 5.1.23-rc possible order by desc bug
Posted by: Mark Harburn
Date: February 18, 2008 07:10AM

SELECT tv.fromClientID AS clientID, tv.trackdate
FROM trackviews tv
LEFT JOIN mym p ON ( tv.fromClientID = p.clientID )
WHERE tv.clientID = 32
ORDER BY trackdate DESC
LIMIT 5

396951 1203236902
396726 1203169865
396492 1203157557
396326 1202945744
395826 1203239851

Is this what you were after?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
5.1.23-rc possible order by desc bug
4960
Mark Harburn
February 16, 2008 02:55AM
Re: 5.1.23-rc possible order by desc bug
2582
Jeffrey Pugh
February 16, 2008 07:04PM
Re: 5.1.23-rc possible order by desc bug
2441
Jeffrey Pugh
February 16, 2008 07:15PM
Re: 5.1.23-rc possible order by desc bug
2430
Mark Harburn
February 17, 2008 11:26AM
Re: 5.1.23-rc possible order by desc bug
2597
Jeffrey Pugh
February 17, 2008 08:36PM
Re: 5.1.23-rc possible order by desc bug
2538
Mark Harburn
February 18, 2008 07:10AM
Re: 5.1.23-rc possible order by desc bug
2329
Mark Harburn
February 18, 2008 07:10AM
Re: 5.1.23-rc possible order by desc bug
2576
Trim Pershad
February 19, 2008 10:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.