I guess MySQL is a DBMS ans not a frontend. > 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] > >
-- Once a problem is defined - it is half way solved. (Henry Ford) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]