Even if you are using a GUI tool to connect to your MySQL servers, one day or another, you will have to deal with the command line. So it is nice to know a few tips that can really make your work easier.
Note: The commands below are only available for Unix/Linux.
Using pager
Most of the graphical tools paginate results, which is very
handy. But this is not the way the command line client works: it
just outputs all results. It can be annoying but it is easily
solved by using the pager
command:
mysql> pager more PAGER set to 'more' mysql> select title from sakila.film; +-----------------------------+ | title | +-----------------------------+ | ACADEMY DINOSAUR | | ACE GOLDFINGER | | ADAPTATION HOLES | | AFFAIR PREJUDICE | | AFRICAN EGG | | AGENT TRUMAN | | AIRPLANE SIERRA | | AIRPORT POLLOCK …[Read more]