To list all of the tables within a mysql database.
As an example we’ll select all the tables from the instruments database.
Run the command once logged into the MySQL and after selecting the database.
To login to mysql
mysql -u username -p
Leaving a missing password parameter value will prompt for the entry of the password.
Once logged in change to the required database. (instruments in our example).
use instruments;
followed by the command to list the tables:
mysql> show tables;
Don’t forget the semi colon on the end of the lines.
