This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes MySQL get the row number Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "MySQL get the row number" Watch "MySQL get the row number" New topic
Author

MySQL get the row number

Jeppe Sommer
Ranch Hand

Joined: Jan 07, 2004
Posts: 270
Hi,

Is it possible in mySQL (4.x) to get the row number using only a SQL query?

The result should be some like:

[ December 20, 2006: Message edited by: Jeppe Fjord ]
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 19351
    
  10

Here's the response that somebody from MySQL gave to that question when it was asked on MySQL's forum.
 
rocket mass heater kickstarter
 
subject: MySQL get the row number