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]