"sanjay gupta" <[EMAIL PROTECTED]> wrote: > thanks for the reply, > > i have tried limit , but i want 10 records at a time and when i hit "return > key" i will show next 10 records, and so on. how i can achieve this .
Use SELECT .... LIMIT 10, 10 to retrieve rows 11-20 > > sanjay > ----- Original Message ----- > From: "Victoria Reznichenko" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, August 19, 2003 2:32 PM > Subject: Re: scroll problem > > >> "sanjay gupta" <[EMAIL PROTECTED]> wrote: >> > >> > I have lot of problem due to scrolling .e.g. When i > give >> > command " select * from table-name" .if the records are more than the > srceen >> > width then i am unable to see all the records ,only last records are >> > visible.Is there any command suffix to SQL commands so that i may able > to >> > see all the records, >> >> Use LIMIT clause to retrieve only certain number of records. You can also > use SELECT .. INTO OUTFILE command: >> http://www.mysql.com/doc/en/SELECT.html >> -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
