-
From: Martin Gainty [mailto:mgai...@hotmail.com]
Sent: 24 September 2012 04:58
To: fuller.art...@gmail.com; pownall...@gmail.com
Cc: mysql@lists.mysql.com
Subject: RE: How to block SELECT * FROM table; but not SELECT * FROMT
table WHERE...;
Possibly run your constructed query thru
problem,
which I guess is performance.
-Original Message-
From: Arthur Fuller [mailto:fuller.art...@gmail.com]
Sent: Sunday, September 23, 2012 3:39 PM
To: Tim Pownall
Cc: mysql@lists.mysql.com
Subject: Re: How to block SELECT * FROM table; but not SELECT * FROMT
table WHERE
Am 23.09.2012 20:23, schrieb Luis Daniel Lucio Quiroz:
Just wondering if is possible to block SELECT queries that doesnt have
a WHERE statement within.
no and the idea is broken by design
what is wrong with a select * from table with small
tbales having only a handful of records?
how will
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.lu...@gmail.com wrote:
Helo,
Just wondering if is possible to block
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
Tim,
I think you misunderstood the question. Daniel wants to block Select
queries that ask for all rwows, and permit only queries that ask for some
rows, as restricted by the Where clause.
Unfortunately, I don't think that can be done. But I'm not certain of that;
there might be a trick.
Arthur
légalement obligatoire. Étant donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
Date: Sun, 23 Sep 2012 18:38:58 -0400
Subject: Re: How to block SELECT * FROM table; but not SELECT * FROMT table
WHERE