MySQL describe | more
In the MySQL shell, enter

pager less


Then enter your query. Use Enter to scroll down and 'q' to stop browsing the results.

My system doesn't have less, so I used more instead:

pager more


More can scroll down and quit like less, but it can't scroll up.