15 Dec
2007
15 Dec
'07
11:04 p.m.
Hi again,
Sebastian Mendel schrieb:
seeing what he queried, if he wrote LIMIT 0,2 we should show two lines per page
What should phpMyAdmin do, if he queries "LIMIT 0,1000000"? Or "LIMIT 1000000"? Displaying a page that might crash his browser might not be his intention. ;-)
And what shall we do in the following case?
SELECT * FROM (SELECT * FROM table LIMIT 0,2) t;
This would be semantically identical to
SELECT * FROM table LIMIT 0,2;
Should we handle it differently? If not, do you really want to walk through each query and collect all limits? :-/
If I wanted to browse the unlimited result, I would omit the LIMIT.
Regards,
Alexander