How to get retail_db tables


From where can I have the 6 tables(order,order_items,products,customers,categories,departments) under retail_db?
and How to login to mysql?

Thanks in advance,


From command prompt, you need to login mysql using the following username and password:
mysql -u retail_dba -h -p
Password:: itversity
Step 2: For finding out the databases list, command is:
show databases;
Step 3: for changing to retail_db database, command:
use retail_db;
Step 4:
show tables;

Then you can able to see all tables of retail_db database.


Thank you very much Ravi .I can see the tables in retail_db database. :slight_smile: