cas Heuman
CM Web Developer
SRA International, Inc.
FAA, WJHTC/Bldg 300, 2nd Fl., H33
Atlantic City Int'l Airport, NJ 08405
Phone 609.485.5401
"J.R. Bullington" <[EMAIL PROTECTED]>
03/28/2007 12:31 PM
Please respond to
[EMAIL PROTECTED]
To
cc
Subject
re: Countin
ble;
SELECT FOUND_ROWS();
J.R.
From: [EMAIL PROTECTED]
Sent: Wednesday, March 28, 2007 10:46 AM
To: mysql@lists.mysql.com
Subject: Counting Row Results inside the select
Has anyone found a way to get a result set with the current
Has anyone found a way to get a result set with the current row return
number in a select statement without using vars?
select concat('Test row ',currentreturnrownum()) as testdata , mytestdata
from mytestdatatable;
++---+
|Test row 1 | testd