ProblemQuery output zooms off the top of your screen before you can see it. SolutionTell mysql to display output a page at a time, or run mysql in a window that allows scrollback. DiscussionIf a statement produces many lines of output, normally the lines just scroll right off the top of the screen. To prevent this, tell mysql to present output a page at a time by specifying the --pager option.[
% mysql --pager=/usr/bin/less --pager by itself (with no option value) tells mysql to use your default pager, as specified in your PAGER environment variable: % mysql --pager If your PAGER variable isn't set, you must either define it or use the first form of the command to specify a pager program explicitly. To define PAGER, use the instructions given in Appendix B for setting environment variables. Within a mysql session, you can turn paging on or off using \P or \n, respectively. \P without an argument enables paging using the program specified in your PAGER variable. \P with an argument enables paging using the argument as the name of the paging program: mysql> \P PAGER set to /bin/more mysql> \P /usr/bin/less PAGER set to /usr/bin/less mysql> \n PAGER set to stdout Another way to deal with long result sets is to use a terminal program that allows you to scroll back through previous output. Programs such as xterm for the X Window System, Terminal for Mac OS X, or the console window for Windows allow you to set the number of output lines saved in the scrollback buffer. Under Windows, you can set up a console window that allows scrollback by using the following procedure:
Now you can launch the shortcut to get a scrollable console window that allows output produced by commands in that window to be retrieved using the scrollbar. |