Return to Answer

You might also find this useful (non-Windows only):

mysql> pager less -SFX mysql> SELECT * FROM sometable; 

This will pipe the output through the less command line tool which - with these parameters - will give you a tabular output that can be scrolled horizontally and vertically with the cursor keys.

Leave this view by hitting the q key, which will quit the less tool.

You might also find this useful (non-Windows only):

mysql> pager less -SFX mysql> SELECT * FROM sometable; 

This will pipe the output through the less command line tool which - with these parameters - will give you a tabular output that can be scrolled horizontally and vertically with the cursor keys.

Leave this view by hitting the q key, which will quit the less tool.

From less manual:

• -S or --chop-long-lines: Causes lines longer than the screen width to be chopped (truncated) rather than wrapped.
• -F or --quit-if-one-screen: Causes less to automatically exit if the entire file can be displayed on the first screen.
• -X or --no-init: Disables sending the termcap initialization and deinitialization strings to the terminal.

You might also find this useful (non-Windows only):

mysql> pager less -SFX mysql> SELECT * FROM sometable; 

This will pipe the output through the less command line tool which - with these parameters - will give you a tabular output that can be scrolled horizontally and vertically with the cursor keys.

Leave this view by hitting the q key, which will quit the less tool.

You might also find this useful (non-Windows only):

mysql> pager less -SFX mysql> SELECT * FROM sometable; 

This will pipe the output through the less command line tool which - with these parameters - will give you a tabular output that can be scrolled horizontally and vertically with the cursor keys.

Leave this view by hitting the q key, which will quit the less tool.

You might also find this useful (non-Windows only):

 mysql> pager less -SFX mysql> SELECT * FROM sometable; 

This will pipe the output through the less command line tool which - with these parameters - will give you a tabular output that can be scrolled horizontally and vertically with the cursor keys.

Leave this view by hitting the q key, which will quit the less tool.

You might also find this useful (non-Windows only):

mysql> pager less -SFX mysql> SELECT * FROM sometable; 

This will pipe the output through the less command line tool which - with these parameters - will give you a tabular output that can be scrolled horizontally and vertically with the cursor keys.

Leave this view by hitting the q key, which will quit the less tool.