Hi John, thanks for the limit tip!
However, I wish to use this as a security tool. I.e. one in which I (as the mysql admin) can do a grant like: "all queries on a specific table from user "apache" must only return 1 record" This would be like forcing a limit of 1 (using the technique below). But thanks for the help nonetheless! --Raj On Tue, 12 Nov 2002, John Ragan wrote: > > see if the limit keyword will do what you want. > > select * from table limit 0, 2000 > > > > > Hi all, > > > > is it possible to limit a result so that only the first record in a query > > can be returned for a specific user? > > > > I want to do this so that someone who does not have intimate knowledge of > > a large (>100000 records) table cannot issue commands to grab *all* of the > > data. > > > > Thanks ahead of time for any info! > > > > --Raj > > > > > > > > -- > John Ragan > [EMAIL PROTECTED] > http://www.CoreReader.com/ > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php