File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
MySQL get the row number
Joined: Jan 07, 2004
Dec 20, 2006 09:10:00
Is it possible in mySQL (4.x) to get the row number using only a SQL query?
The result should be some like:
Row ID Name 1 000981 Peter 2 093388 Jane 3 000987 Alies ...
[ December 20, 2006: Message edited by: Jeppe Fjord ]
Joined: Oct 14, 2005
Dec 20, 2006 09:35:00
Here's the response that somebody from MySQL gave to that question when it was asked on
I agree. Here's the link:
- it saves me about five hours per week
subject: MySQL get the row number
retrieve blob data from mysql using jsp
Row Selection problems with JTable
getting a range of returned rows?
selecting a row from table using radio buttons
loading objects into arraylist
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013