* 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]