
16 Dec
2007
16 Dec
'07
2:04 a.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