A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
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
It is sorta covered in the
JavaRanch Style Guide
subject: MySQL get the row number
loading objects into arraylist
selecting a row from table using radio buttons
Row Selection problems with JTable
retrieve blob data from mysql using jsp
getting a range of returned rows?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015