[Phpmyadmin-devel] about explicit LIMIT

[Marc Delisle]

Sebastian Mendel a écrit :
> Marc Delisle schrieb:
>> Hi,
>> I am seeking your input about the following issue. Normally if a user 
>> just browses a table, he can use the navigation << < > >> and "Page 
>> number" to move thru the table. LIMIT clause is generated accordingly.
>>
>> Now if a user typed a LIMIT clause, what should he expect?
> 
> seeing what he queried, if he wrote LIMIT 0,2 we should show two lines per page
> 
> 
>> (1) To be able to move thru the entire table
>> (2) or just thru the result set he chose in his LIMIT clause?
> 
> table = result !?

No sure I understand your question, but the result set from a query is 
different than showing the plain table. See the other answer by Alexander.
> 
> (1) with his limit as initial rows per page
> 
> 
I thought about this. We could use his "LIMIT x,y" to fill the "Show y 
rows starting with record #x". But I'm still not sure: why did the user 
put an explicit LIMIT? To limit the initial display, or because he's 
really not interested in seeing other rows?