Re: Show record index, limit

[gerald_clark]

Juan Carlos wrote:

Hello Everybody
I using MySQL and I want to show the record id for the SELECT
I know you can do
SELECT clientCode, clientName limit 20, 3
   2030    John
   2040    Charles
   2050    Mery
The limit show from record 21 (record id = 20) because the first start in 0
I want to show that record id (index, code)  in the Select
   20    2030    John
   21    2040    Charles
   22    2050    Mery
 

This is an incorrect assumption.
There is no record id used here.
You are dealing with array indicies,
You are simply telling it to throw away the first 20 lines in the output 
set,
send the next 3, and throw the rest away.

---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php