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 .
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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]