How to obtain same effect as 'less' in Linux in mysql?
i.e. the output display stops at the first screen, before you can move the output in vi way.
$pager less
$select * from table;
Furthermore, use -
$pager less
$select * from table\G
so that fields are displayed from up to down, instead of from left to right.
ls | more although most people use the ls | less command as it has more features, such as scrolling back as well as forwards, and searching for text./something.man less for more details. > mysql -p [database]
Enter password:
mysql> pager more;
PAGER set to more
mysql> select * from [table];
...data...
...data...
--More--
You can use 'less', or 'more', or whatever other pager you want to use.