[Phpmyadmin-devel] about explicit LIMIT

Sebastian Mendel lists at sebastianmendel.de
Sat Dec 15 20:45:52 CET 2007


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 !?

(1) with his limit as initial rows per page


-- 
Sebastian




More information about the Developers mailing list