Thanks for the valuable tips sanjay ----- Original Message ----- From: "Rob A. Brahier" <[EMAIL PROTECTED]> To: "Roger Baklund" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: "sanjay gupta" <[EMAIL PROTECTED]> Sent: Tuesday, August 19, 2003 11:15 PM Subject: RE: scroll problem
> If you are using *nix, fire up the mysql command-line client and type the > following: > > \P more > > Then hit enter. That forces the client to pass all of its output through > the more command and will thus return a screen's worth of records at a time. > \P will pipe the client's output through whatever you wish. If you want to > turn this feature off, just type \n on a new line all by itself. (Note that > this must be typed each time you start up the client app...) > > -Rob > > -----Original Message----- > From: Roger Baklund [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 19, 2003 8:42 AM > To: [EMAIL PROTECTED] > Cc: sanjay gupta > Subject: Re: scroll problem > > > * sanjay gupta > > 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 . > > Depending on your OS, you could try something like this: > > $> mysql -e "SELECT * FROM tablename" database | more > > It won't give you 10 rows, but the number of rows that fits your screen. > > Note that 'more' is a OS utility, not a part of mysql. > > This should work on win, linux & unix. > > If you run unix/linux, try 'less' instead of 'more'... should give you also > page-up/page-down... ;) > > -- > Roger > > > > -- > 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]