that does not change the fact that it is valid to NOT have a where
statement and for me it sound plain stupid to think about blocking
queries without where-statements - the application developers will
hopefully kill any admin who finds a solution for this...........
* i maintain a cms-system since 10 years
* mainmenu: select id,title from table order by sortfield;
* and YES in the backend the is no single reson to reduce the result
* and NO using a key would not make anything faster
so why would there be a WHERE make any sense and why does
someone like to break the application just for fun?
Am 23.09.2012 21:50, schrieb Tim Pownall:
> select * from table where column=value means it will return only rows that
> match. as long as you have proper indexing there should not be any issues.
> On Sun, Sep 23, 2012 at 1:23 PM, Luis Daniel Lucio Quiroz <
> luis.daniel.lucio@stripped> wrote:
>> Just wondering if is possible to block SELECT queries that doesnt have
>> a WHERE statement within.
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc