Setup DB In Local

Mysql Workbench

1. Install Mysql Workbench
   • Video for install MySql Workbench
2. Find the required DB details in the .env file. (Make sure you have DB details and access)
3. Pin Mysql Workbench in your taskbar
4. Points to remember
   • Before you connect to DB connect your VPN
5. How to use Mysql Workbench & Run Query
   • Video for run query in Mysql Workbench
   • Run query

Some useful query

• To see all the tables

SHOW TABLES

• To Check Attributes

USE toolstation_fr;

SELECT * FROM sys_status;

• To check stock location

USE toolstation_fr;

SELECT * FROM stock_location_desc;

• To check user orders

There are three types of order (Orders from web, Orders from App & Orders from shops)

USE toolstation_fr;

SELECT * FROM user_orders;

• To check users accounts

USE toolstation_fr;

SELECT * FROM sys_users;