How to see all the records when you run MySQL show tables

Written by James McDonald

August 7, 2015

Sometimes the database you are viewing with the mysql client has so many tables you can’t see all of them because the first results are hidden.

In the mysql client

pager less;

Now when you run show tables; it will pipe it to less and you will be able to see the whole lot.

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

You May Also Like…

Unifi LAN LOCAL IN OUT

This is a graphic I use to figure out which section to add the firewall rules to in the Unifi UDM/USG controller....