At 16:15 -0400 6/26/02, Anil Garg wrote:
>for viewing long tables.
>in my sql query when i say SELECT * FROM abc
>i miss the upper entries of the table as they scroll down.
>is there something by which i can view a table page by page(as | more in
Yes, if you *are* using Unix. Start mysql with the --pager option.
This will use the value of your PAGER environment variable as the
program though which to page query results. If PAGER isn't set,
you can use something like "mysql --pager=/usr/bin/more" to specify
the pager program explicitly.
Within mysql, you can turning paging on or off with
Requires MySQL 3.23.28 or above.