Neil,
You can limit the number of records returned by any query by appending "
LIMIT x, y " or "LIMIT y"
where x is the offset of the first row you want, and y is the maximum
number of records to return.
For example, "select * from testtable LIMIT 2 " would return the first 2
rows from the table
* Neil Tompkins
>
> Are there any settings I can set to limit the number of records returned ?
Yes, the LIMIT clause of the SELECT statement:
http://www.mysql.com/doc/S/E/SELECT.html >
--
Roger
query
-
Before posting, please
