In this post i will explain how to select a schema and list down all tables in mysql DB.
First login to mysql command using below command,
Enter your password:
and then by use command select schema as below,
this command will select schema. Now use show tables command to list all tables.
mysql> show tables;
this will list down all tables in test schema, as shown in below screenshot.