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.


Submit a Comment

Your email address will not be published.

You May Also Like…

MacOS USB Creator

Just toasted my Windows 10 Pro install with a Windows 11 upgrade. Think it will be unrecoverable (because of Bitlocker...