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 *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The reCAPTCHA verification period has expired. Please reload the page.

You May Also Like…