"SELECT *" yields too many rows to show! How do I scroll through all results?

Databases
1

When I use: SELECT * FROM download_log;
I have 1300+ rows of data but using putty I cannot scroll to the top of the results, I can only see about 100 results!:eek2:

How do I scroll through the rest of them?

or should I write up a php script to display this information on a page?

2

Do you have PHPMyAdmin available to you to access the database concerned?

3

No I do not use phpAdmin i just use the putty command prompt to access my server and MySQL db. I am under the impression that phpAdmin is not free.

4

That impression would be incorrect. PHPMyadmin is free tool and should be included from your host if you have access to mysql via cpanel.

5

While I fool around with installing PHPMyAdmin…

I am still curious if anyone knows a way to scroll through many rows of data in a table using the bash shell command prompt interface?