To display all tables in a database you need to execute the following commands:
use databasename;
First of all you will go inside your database. Suppose your database name is demo then you will execute the above MySQL statement as:
use demo;
Then you will execute the following MySQL statement to display all the tables:
show tables;
Above statement will display all the tables of demo database.
0 Comment(s)