Limit the output 2

[tikual]

Hi all,

If the selected output are 100 records, is it possible to output it 20 records each time? I want to get the result by 5 times. Thanks all!

tikual

 

[DonQuichote]

Yep. Check the LIMIT clause in the documentation.

+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)

 

[tikual]

Hi DonQuichote,

It seems that LIMIT only limits a range of output but not output 20 records each time.

tikual

 

[ingresman]

the syntax is limit offset,amount so select 1,20 would return rows 1 to 20 ,issue select 21,20 would give you 21 to 40 and so on

 

[r937]

select 21,20 would give you 21 to 40 and so on

this is a common error


the first parameter after LIMIT is the number of rows to skip over

so LIMIT 21,20 actually gives you rows 22 through 41

r937.com | rudy.ca

 

[ingresman]

Yes well spotted !, if I'd read the text corectly when researching on the mysql documentation for the limit clause on the select (by typing mysql limit in google! ) I would have seen it !

 

[tikual]

Thanks r937 and ingresman!

tikual