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. Required fields are marked *

You May Also Like…

Scam call from “Telstra”

Just had a call from a man with a sub-continental accent from caller ID 0734946596 Told me there was problem with my...

PC Build

I recently built myself a PC using the SilverStone SG13 Case. I am planning to use it as a Hot Spare. So any client...