Hi, Or if you are interested in limiting the number of rows add a limit clause, so that entire resultset of entire table is not returned ,
I am not sure how will that be done , but i have seen some GUIs doing that, would look for a solution from group. Thanks Abhishek > -----Original Message----- > 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 a regex expression e.g. > String mydata = "SELECT * from table WHERE a<b;"; Pattern pattern = > Pattern.compile("'WHERE'"); Matcher matcher = pattern.matcher(mydata); > if (matcher.find()) { //WHERE clause found proceed normally } else > throw new Exception("WHERE clause not found"); Martin > ______________________________________________ > Verzicht und Vertraulichkeitanmerkung/Note de déni et de > confidentialité > > Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene > Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede > unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. > Diese Nachricht dient lediglich dem Austausch von Informationen und > entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten > Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt > uebernehmen. > Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas > le destinataire prévu, nous te demandons avec bonté que pour satisfaire > informez l'expéditeur. N'importe quelle diffusion non autorisée ou la > copie de ceci est interdite. Ce message sert à l'information seulement > et n'aura pas n'importe quel effet 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...; > > From: fuller.art...@gmail.com > > To: pownall...@gmail.com > > CC: mysql@lists.mysql.com > > > > 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 > > www.artfulsoftware.com > > > > On Sun, Sep 23, 2012 at 3:50 PM, Tim Pownall <pownall...@gmail.com> > wrote: > > > > > 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: > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql