MySQL Lists: mysql: Re: How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...;

List:	General Discussion	« Previous Message Next Message »
From:	Tim Pownall	Date:	September 23 2012 7:50pm
Subject:	Re: How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...;
View as plain text

 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:

> Helo,
>
> Just wondering if is possible to block SELECT queries that doesnt have
> a WHERE statement within.
>
>
> LD
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>

-- 

Thanks,

Tim Pownall
GNU/Linux Systems Monitoring
610-621-9712
pownalltim@stripped

Thread
• How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...;	Luis Daniel Lucio Quiroz	23 Sep
• Re: How to block SELECT * FROM table; but not SELECT * FROMT tableWHERE...;	Reindl Harald	23 Sep
• *Re: How to block SELECT FROM table; but not SELECT * FROMT table WHERE...;**	Tim Pownall	23 Sep
• Re: How to block SELECT * FROM table; but not SELECT * FROMT tableWHERE...;	Reindl Harald	23 Sep
• Re: How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...;	Arthur Fuller	23 Sep
• RE: How to block SELECT * FROM table; but not SELECT * FROMT tableWHERE...;	Rick James	24 Sep
• RE: How to block SELECT * FROM table; but not SELECT * FROMT tableWHERE...;	Martin Gainty	23 Sep
• RE: How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...;	abhishek jain	24 Sep