Row select in old mysql versions
We are using MySQL version 4.0.20-standard.
Our application requires a query to do a row select. From what I have found this version does not support rownum. We are unable to update the version of MySQL. Can anyone give us some support.
e.g.
Select * from table where rownum=1242;
Any help would be greatly appreciated.
Subject
Written By
Posted
Row select in old mysql versions
June 29, 2005 10:14AM
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.