How to get retail_db tables


#1

Hi,
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,
Aparna


#2

From command prompt, you need to login mysql using the following username and password:
Step.1:
mysql -u retail_dba -h nn01.itversity.com -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.


#3

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


#4