lets discuss now how we can check how many tables exist in a MySQL database .
Step 1) Login to MySQL
we will be using user : demo and password as demouser
mysql -u demo -p demouser
Step 2) use database in which we need to check table , as in our previous post we created database demo we will be using same database
mysql> use demo;
Step 3) we will use command show tables ;
+—————-+
| Tables_in_demo |
+—————-+
| employee |
+—————-+
1 row in set (0.00 sec)
this will list all the tables which are under demo database.
In our next post we will discuss how to insert data in a MySQL Table.
