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

Sometimes the database you are…

Login

Blog History

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 *

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.